Upgrade is completed from build 8896 to 9032 but it still shows old build 8896 instead of 9032 in Platform - options

Avatar

Avatar
Boost 3
Level 2
abhilashs813504
Level 2

Likes

2 likes

Total Posts

19 posts

Correct reply

5 solutions
Top badges earned
Boost 3
Establish
Give Back
Boost 1
Affirm 5
View profile

Avatar
Boost 3
Level 2
abhilashs813504
Level 2

Likes

2 likes

Total Posts

19 posts

Correct reply

5 solutions
Top badges earned
Boost 3
Establish
Give Back
Boost 1
Affirm 5
View profile
abhilashs813504
Level 2

16-07-2020

Upgrade is completed from build 8896 to 9032 but it still shows old build 8896 instead of 9032

Administration - Platform – Options – Last Upgrade – Still pointing to old build 8896 (Screenshot attached)

builddisplay.PNG

 

Though the Help-About Section from client console shows the correct version 9032 for server/client.

 

Below are the steps which i did to resolve the issue but still the issue persists.

1.Cleared the hard cache and soft cache for the user account doing the upgrade from the server

2.Rebooted the app server and restart IIS and Adobe campaign services

3.I tried running the database upgrade with -force option but it didn’t help.

 

Posting warnings and errors during the database update from instance -

17:52:35 >>  Warning! Continuous delivery detected in workflow id: 14986929 internalName: (instancename)_WKF387 label: Delivery Log Test template of delivery will be updated for security reason

17:52:35 >>  template delivery id: 14984021 tsLastModified updated

17:52:35 >>> WDB-200001 SQL statement 'SELECT   W0.iWorkflowId, W0.sInternalName, W0.sLabel, W0.sDesc, W0.iCreatedById, W0.iModifiedById, W0.tsCreated, W0.tsLastModified, W0.iSupervisorId, W0.sTimezone, W0.iInProcess, W0.iHistory, W0.iOnError, W0.iErrorLimit, W0.iBuiltIn, W0.iIsModel, W0.sForm, W0.iFolderId, W0.iFolderProcessId, W0.tsLastStart, W0.tsNextProcessing, W0.sNextProcessingAfn, W0.sNextProcessingHost, W0.iStatus, W0.iProduction, W0.iFailed, W0.iUnlockedCount, W0.iState, W0.tsProcess, W0.iProcessId, W0.sHostname, W0.iPort, W0.iOperationId, W0.iStartState, W0.iPriority, W0.iForecasted, W0.sLogin, W0.iRoutingOperationId, W0.iAggregateId, W0.iOrder, W0.tsExpiration, W0.iRecurrentMdl, O1.iOperatorId, O2.iOperatorId, O3.iOperatorId, F4.iFolderId, F5.iFolderId, O6.iOperationId, O7.iOperationId, O8.iOlapAggregateId, W0.mData, W0.mVisualState FROM XtkWorkflow W0 JOIN XtkOperator O1 ON (O1.iOperatorId = W0.iCreatedById) JOIN XtkOperator O2 ON (O2.iOperatorId = W0.iModifiedById) JOIN XtkOperator O3 ON (O3.iOperatorId = W0.iSupervisorId) JOIN XtkFolder F4 ON (F4.iFolderId = W0.iFolderId) JOIN XtkFolder F5 ON (F5.iFolderId = W0.iFolderProcessId) JOIN NmsOperation O6 ON (O6.iOperationId = W0.iOperationId) JOIN NmsOperation O7 ON (O7.iOperationId = W0.iRoutingOperationId) JOIN XtkOlapAggregate O8 ON (O8.iOlapAggregateId = W0.iAggregateId) WHERE (W0.iWorkflowId = :1)' could not be executed.

  Param(0)=17303419 (iRc=-2003)

17:52:35 >>> WDB-200011 The requested database record does not exist. (iRc=-2003)

17:52:35 >>> Unable to load document of type 'Workflows (xtk:workflow)' because link 'modifiedBy' with condition '@id = 4218895' not found in the database. (iRc=-53)

17:52:35 >>> SOP-330011 Error while executing the method 'ExecuteQuery' of service 'xtk:queryDef'. (iRc=-53)

17:52:35 >>> SCR-160012 Javascript: error while evaluating script 'inline'. (iRc=-53)

17:52:35 >>> XSV-350063 No data source defined in the instance 'default'. Make sure the DNS alias used to access the server is correct (for example, avoid hard-coded IP addresses). (iRc=16384)

17:52:35 >>> CFG-600010 Document update job stopped after an error (iRc=-53)

17:52:35 >   CFG-600021 default instance, no warning during update.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 100
MVP
_Manoj_Kumar
MVP

Likes

117 likes

Total Posts

329 posts

Correct reply

102 solutions
Top badges earned
Affirm 100
Validate 1
Contributor
Ignite 1
Shape 1
View profile

Avatar
Affirm 100
MVP
_Manoj_Kumar
MVP

Likes

117 likes

Total Posts

329 posts

Correct reply

102 solutions
Top badges earned
Affirm 100
Validate 1
Contributor
Ignite 1
Shape 1
View profile
_Manoj_Kumar
MVP

21-07-2020

Hello @abhilashs813504 ,

 

According to below documentation, NmsServer_LastPostUpgrade holds the Build number of the AC instance before the last upgrade. Then i believe you are looking at the correct value.

 

https://guided.adobe.com/docs/campaign-classic/using/installing-campaign-classic/appendices/configur...

 

Thanks,

Answers (3)

Answers (3)

Avatar

Avatar
Validate 1
Level 2
Prasanna_Soni
Level 2

Like

1 like

Total Posts

67 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Ignite 1
Give Back
Affirm 1
View profile

Avatar
Validate 1
Level 2
Prasanna_Soni
Level 2

Like

1 like

Total Posts

67 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Ignite 1
Give Back
Affirm 1
View profile
Prasanna_Soni
Level 2

07-08-2020

I faced similar problem and yes you will need to resolve the error with ">>>" arrows and once done you can rerun 

additionally try below command .Please note you can try from Web server as well . It need not to be run only from app server , that might solve your problem as behind database is same. Assuming its hybrid model 

 

nlserver config -postupgrade -allinstances

 

 

Avatar

Avatar
Establish
Employee
Adhiyan
Employee

Likes

241 likes

Total Posts

343 posts

Correct reply

124 solutions
Top badges earned
Establish
Give Back 50
Give Back 25
Give Back 10
Give Back 5
View profile

Avatar
Establish
Employee
Adhiyan
Employee

Likes

241 likes

Total Posts

343 posts

Correct reply

124 solutions
Top badges earned
Establish
Give Back 50
Give Back 25
Give Back 10
Give Back 5
View profile
Adhiyan
Employee

07-08-2020

Hello Abhilash,

 

I think the option does not show the correct build is because the postupgrade process ran into an error.

The postupgrade does the schema updates one by one and it's gets stopped at xtk:workflow and hence is not able to complete as the xtk:option table is not updated.

 

You should resolve the error related to xtk:workflow where it's complaining about a missing modified by ID . If you look into the workflow table and find out the foreign key for modified-id , and filter out the results using the ID given in the error . I would assume that some user in the past would have modified one / few workflows which no longer exist.

 

So to solve the problem you should either update the workflow table with the foreign key link for modified-id with an user id which exist or delete the workflows that are not needed and then perform the postupgrade -force again.

 

Regards,

Adhiyan

Avatar

Avatar
Boost 3
Level 2
abhilashs813504
Level 2

Likes

2 likes

Total Posts

19 posts

Correct reply

5 solutions
Top badges earned
Boost 3
Establish
Give Back
Boost 1
Affirm 5
View profile

Avatar
Boost 3
Level 2
abhilashs813504
Level 2

Likes

2 likes

Total Posts

19 posts

Correct reply

5 solutions
Top badges earned
Boost 3
Establish
Give Back
Boost 1
Affirm 5
View profile
abhilashs813504
Level 2

22-07-2020

Hello @_Manoj_Kumar , The value should be showing the latest Upgrade build as it correctly shows in other environment except this one. The document referred assumes that let say for instance the environment going forward needs to be upgraded to build 9035 for which the last upgrade value should be pointing to 9032 and not any version prior to that.

 

Thanks,

Abhi