Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Database cleanup Error

uagnihotri
Level 3
Level 3

While running the DB cleanup workflow, the workflow fails while running the "Updating RDBMS statistics (up_updatestats)...", the workflows fails with error as given below:

2018-06-06 15:40:35.640-06 0000CA88 0000CB30   1 verbose log Updating RDBMS statistics (up_updatestats)...

2018-06-06 15:40:35.988-06 0000CA88 0000CB30   1 error log ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Updating NmsOperation SQLState: 01000 (iRc=-2006)

2018-06-06 15:40:35.988-06 0000CA88 0000CB30   1 error log ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Updating XtkFileRes SQLState: 01000 (iRc=-2006)

Could anyone provide me any details on this "up_updatestats"? The DB workflow used to run successfully in past. It recently started throwing this error.

Note: Other workflows runs successfully without error (marketing and non-marketing workflows).

1 Accepted Solution
uagnihotri
Correct answer by
Level 3
Level 3

This the only information logged by Campaign. SQLState: 01000 is misleading.

We have resolved the issue by changing the up_updatestats stored procedure. The code in the stored procedure doesn't handle the tables properly which are not owned by the DB owner of the Campaign Database.

View solution in original post

3 Replies
Vapsy
Employee
Employee

Hi there,

Can you please share the error message. The 3 lines you have shared don't share much information.

Are these the only error logs or if there is more to it

Regards,
Vipul

uagnihotri
Correct answer by
Level 3
Level 3

This the only information logged by Campaign. SQLState: 01000 is misleading.

We have resolved the issue by changing the up_updatestats stored procedure. The code in the stored procedure doesn't handle the tables properly which are not owned by the DB owner of the Campaign Database.

View solution in original post

Jean-Serge_Biro
Community Advisor
Community Advisor

Hi uagnihotri,


We did the same in 2015, by adding a where clause to exclude all objects belonging to another schema than the user neolane (adobe campaign) that owns the AC tables, for our SQL Server DB.

We provided to Adobe Campaign support this information in 2015 in order they could integrate this correction in future releases, but not done yet.


So please take care when upgrading your AC instance (build update), you have to keep changes safe (backup).
It is not managed by the Conflict management of postupgrade process, as far as I know.

Regards
J-Serge