We are facing issue connecting to Adobe Campaign using Adobe client console. Error is SOP-330021 Communication error with the server: please make sure it is configured correctly.
HTTP code 500 'A technical error has occurred: ODB-240000 ODBC error: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Login failed for user 'ACM'. SQLState:28000
Unable to connect to database 'hostname, port' of type 'ODBC' with the login 'ACM:database'
MS SQL Server is set as backend database for Adobe Campaign and is pointing to server '10.10.10.10', and we want to change the pointer to '11.11.11.11'. Now as we are not able to login to Adobe campaign we aren't able to make the changes.
We have raised with Adobe and direct us to Database team. From database team they have already provided the user id and password to us which is working in ODBC and appears good enough. Have anybody faced similar issue (or anyway work round to make the changes from backend) as we are stuck at the movement.
Regards
Samir
Views
Replies
Total Likes
Hello @samirghogale ,
it is what it says your database server is down. I guess it was resolved by now.
Marcel
Hi Marcel,
Thanks for replying, but the problem isnt resolved yet. The database server is up and running, we are able to access the DB and I have the credentials. I tried to set the connection with nlserver command "nlserver config -instance:INSTANCENAME -setdblogin:<[dbms:]account[:database][/password]@server>. But not luck. Seems the services aren't getting up, when I run "nlserver pdump -who" I get the same error.
Regards
Samir
Views
Replies
Total Likes
It was working before I assume? And the instance was deployed as per docuentation right?
I guess if you have access to the adobe admin console open ticket with support or deploy entire instance again or maybe remove configuration files and try to configure instance again but reuse already existing database.
Marcel Szimonisz
MarTech Consultant
for more tips visit my blog
https://www.martechnotes.com/
Views
Replies
Total Likes
Hello Samir,
Was this ever resolved? I have having the same issue. We had on prem servers and now moved to Azure servers. I reinstalled ACC on the new azure servers and tried to Connect to our DB (SQLSERVER), which also sits on a azure server. for some reason, the connect fails. Below is from the logs (I turned on verbose)
Note: Server and passwords are changed
2023-01-25 15:56:42.236Z 000025E8 00001E58 1 info log Starting 1 connection(s) on pool 'default dev_app' (mssql, server='AzureDBserver', login='CampaignDEV:CampaignDEV')
2023-01-25 15:56:42.236Z 000025E8 00001E58 1 verbose log Formed a MSSQL/Synapse connection string: 'APP=nlserver wfserver;SERVER=AzureDBserver;DATABASE=CampaignDEV;UID=AdobeCampaignDev;PWD=hidden;Driver={SQL Server Native Client 11.0};'
2023-01-25 15:56:42.252Z 000025E8 00001E58 1 info wdbc Get: [2253573562816] SELECT ServerProperty('EngineEdition')
2023-01-25 15:56:42.252Z 000025E8 00001E58 1 info wdbc Get: [2253573562176] SELECT ServerProperty('productVersion')
2023-01-25 15:56:42.252Z 000025E8 00001E58 1 info wdbc Get: [2253573562176] SELECT SCHEMA_NAME()
2023-01-25 15:56:42.252Z 000025E8 00001E58 1 info wdbc Get: [2253573562176] select GetDate()
2023-01-25 15:56:42.252Z 000025E8 00001E58 1 info wdbc Get: [2253573562176] SELECT GetDate(), iOptionId, iDataType, sStringValue, iLongValue, dDoubleValue, tsTimeStampValue, mMemoValue FROM XtkOption WHERE sName=?
2023-01-25 15:56:42.252Z 000025E8 00001E58 2 info wdbc Param(0)=NmsServer_LastPostUpgrade
2023-01-25 15:56:42.267Z 000025E8 00001E58 1 error log ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'XtkOption'. SQLState: S0002 (iRc=-2006)
2023-01-25 15:56:42.267Z 000025E8 00001E58 1 error log ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. SQLState: 37000 (iRc=-2006)
2023-01-25 15:56:42.267Z 000025E8 00001E58 1 error log WDB-200001 SQL statement 'SELECT GetDate(), iOptionId, iDataType, sStringValue, iLongValue, dDoubleValue, tsTimeStampValue, mMemoValue FROM XtkOption WHERE sName=?' could not be executed.\n Param(0)=NmsServer_LastPostUpgrade (iRc=-2006)
2023-01-25 15:56:42.267Z 000025E8 00001E58 1 warning log XSV-350152 Unable to connect to the database. Will retry in 30 seconds...
2023-01-25 15:57:12.709Z 000025E8 00001E58 1 info log Stop requested (pid=9704)
2023-01-25 15:57:12.709Z 000025E8 00001E58 1 info log Stopping workflow server (pid=9704, tid=7768)...
Regards,
Vasanth
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies