Create_SHDDBCON faild with SQL1531N during EHP 8 upgrade

[former_member298064]

I am getting below error during ehp 8 upgrade. in Phase " Executing actual phase 'MAIN_SHDIMP/SUBMOD_SHD2_RUN/CREATEDBCON_ORIG'.

"

My DB SID is ZTD but somehow it is looking for "FMT" which is my SAP SID ..

i have checked db2cli.ini file , it has ZTD ... i tired to add FMT but no sucess ..

Error

"""2 ETQ373 parameter "EV_ERRMESSAGE" = "SQL1531N The connection failed because the name specified with the DSN connection string keyword could not be found in either the db2dsdriver.cfg configuration file or the db2cli.ini configuration file. Data source name specified in the connection string: "FMT" """

[prabhu_koneru]

Hi Sikandar, I have the same issue. DB an SAP sid are different. I tried changing DBCO in shadow, but when i rerun this phase it puts back SAP sid. Couldn't find that file tnsnames.ora. Any idea where SUM gets that dbname.

[former_member272744]

Dear Sikandar!

I have the same error. Did you fix it?

SAP SID & DB have different SIDs too.

[Reagan]

Have you checked the SAP note 1564507 - DB6: SQL1531N alias "DBNAME" not found in db2dsdriver.cfg

[former_member298064]

Yes, i checked that note..

and try to add FMT in the db2cli.ini file but no luck

[Reagan]

When you say that the DB ID is ZTD and SAP ID is FMT, does that mean that the DB and the SAP are having different SID's?

[former_member298064]

Yes, SAP SID & DB have differnet SID's.

DB SID = ZTD

SAP SID = FMT

[former_member298064]

here are the logs .

1 ETQ200 Executing actual phase 'MAIN_SHDIMP/SUBMOD_SHD2_RUN/CREATEDBCON_ORIG'.

1 ETQ399 Phase arguments:

2 ETQ399 Arg[0] = 'SHD2ORIG'

4 ETQ399 Set database connect to shadow.

4 ETQ399 Set environment for shadow connect:

4 ETQ399 Set RFC variables for shadow connect:

4 ETQ399 System-nr = '03', GwService = 'sapgw03' Client = '000'

4 ETQ380 computing toolpath for request "TP_SHADOW_CONNECT"

4 ETQ381 request "TP_SHADOW_CONNECT" means "tp needs to connect to shadow system"

4 ETQ382 translates to group "TOOL_GROUP_NEW"

4 ETQ399 Requirement for tp maps to 'exe'

4 ETQ383 translates to path "/tmp/as/SUM/abap/exe"

4 ETQ399 Set tool parameters for shadow connect with TPPARAM 'SHADOW.TPP'.

1 ETQ359 RFC Login to: System="FMT", AsHost="erpprd" Nr="03", Client="000", GwHost="erpprd", GwService="sapgw03"

2 ETQ232 RFC Login succeeded

4 ETQ010 Date & Time: 20181024191245

1 ETQ233 Calling function module "CREATE_SHDDBCON" by RFC

2 ETQ373 parameter "DBUSER" = ""

2 ETQ373 parameter "CONENV" = ""

2 ETQ373 parameter "UPGMODE" = "X"

2 ETQ373 parameter "DBMS" = ""

2 ETQ373 parameter "TEST_CONNECTION" = "X"

1 ETQ234 Call of function module "CREATE_SHDDBCON" by RFC succeeded

4 ETQ010 Date & Time: 20181024191245

2 ETQ374 parameter "EV_RC" = "-1531"

2 ETQ373 parameter "EV_ERRMESSAGE" = "SQL1531N The connection failed because the name specified with the DSN connection string keyword could not be found in either the db2dsdriver.cfg configuration file or the db2cli.ini configuration file. Data source name specified in the connection string: "FMT"

1EETQ399 Last error code set is: CREATE_SHDDBCON failed with

1EETQ399X'SQL1531N The connection failed because the name specified with the DSN connection string keyword could not be found in either the db2dsdriver.cfg configuration file or the db2cli.ini configuration f

1EETQ399Xile. Data source name specified in the connection string: "FMT'

1EETQ204 Upgrade phase "CREATEDBCON_ORIG" aborted with severe errors ("20181024191245")

[Reagan]

OK. This looks like that the issue is with the configuration files for the shadow instance. Can you check for the db2cli.ini file and the shadow instance profiles for any entries with the DB ID?

[former_member298064]

Checked Profiles files in Shadow System but not find anything releated to this.... I was not able to find db2cli.ini file in shadow instace ... any idea where i can find this.

[Reagan]

I do not have a DB2 system to check now but I remember there was a tnsnames.ora file used by the SUM tool in one of its sub directories for connecting to the database. I would do a search using the "find" command under the SUM directory for that file and if not you may put a ticket to SAP Support.

[former_member298064]

Thanks for the input , i did R3trans -d and as per log it is loading db2 driver file from /usr/sap/ directory ..

and databse connection is sucessfull.

do you know which file SUM is reading in current phase "CREATE_SHDDBCON" if i can find that i will try to edit that file ..

[former_member298064]

reagan.benjamin