Not able to login Adobe campaign client console - Hybrid setup

[samirghogale]

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

[Marcel_Szimonisz]

Hello @samirghogale ,

it is what it says your database server is down. I guess it was resolved by now.

Marcel

[samirghogale]

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

[Marcel_Szimonisz]

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/

[vasanthrede]

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