Installation Error-PI Usage Type

[Former Member]

Dear All

We are installing SAP with PI as usage type and during "update database configuration" phase we are receiving error which says"sql1013n the database alias name or database name XD1 could not be found".We tried creating the database manually and were able to connect to it also however we arent able to get rid of this error.Also let us know how to update the instance on windows.

SAP Version:NW70

DB:DB6

OS:Windows 2003

Thanks in Advance

Arun

[former_member208104 · Accepted solution]

Hi,

What db you are using ? Can you please provide installation log ?

-Sanjay

[Former Member · Accepted solution]

Dear Sanjay

The DB is DB2 UDB V9.1 FP9 and below is the sapinst.log

INFO 2011-04-23 13:53:36

Creating file C:\Program Files\sapinst_instdir\ERP\SYSTEM\DB6\CENTRAL\AS\update_db_cfg.log.

INFO 2011-04-23 13:53:36

Switched to user: db2xd1.

INFO 2011-04-23 13:53:36

Working directory changed to C:\Program Files\sapinst_instdir\ERP\SYSTEM\DB6\CENTRAL\AS.

INFO 2011-04-23 13:53:36

Output of db2cmd.exe /C /w /i db2 -tvf update_db_cfg.sql -r update_db_cfg.res -z update_db_cfg.out is written to the logfile update_db_cfg.log.

WARNING 2011-04-23 13:53:37

Execution of the command "db2cmd.exe /C /w /i db2 -tvf update_db_cfg.sql -r update_db_cfg.res -z update_db_cfg.out" finished with return code 4. Output:

UPDATE COMMAND OPTIONS USING S OFF

DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING A OFF

DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING X ON

DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING O ON

DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING N OFF

DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

set client CONNECT_DBPARTITIONNUM 0

DB20000I The SET CLIENT command completed successfully.

connect to XD1

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING SELF_TUNING_MEM OFF

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING DATABASE_MEMORY COMPUTED

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING SHEAPTHRES_SHR 20000

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING LOGFILSIZ 16380

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING LOGPRIMARY 20

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING LOGSECOND 40

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING DBHEAP 60000

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING LOGBUFSZ 512

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING BUFFPAGE 10000

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING LOCKLIST 20000

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING APPGROUP_MEM_SZ 128000

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING GROUPHEAP_RATIO 25

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING LOCKTIMEOUT 3600

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING SORTHEAP 2048

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING APPLHEAPSZ 4096

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING MAXLOCKS 90

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING UTIL_HEAP_SZ 10000

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING STMTHEAP 5120

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING PCKCACHESZ 1000

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING TRACKMOD ON

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING CHNGPGS_THRESH 5

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING MAXFILOP 1950

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING CATALOGCACHE_SZ 2560

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING SOFTMAX 200

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING NEWLOGPATH E:\db2\XD1\log_dir

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING APP_CTL_HEAP_SZ 1600

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING REC_HIS_RETENTN 60

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING STAT_HEAP_SZ 15000

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING AUTO_RUNSTATS OFF

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING DFT_PREFETCH_SZ AUTOMATIC

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

UPDATE DB CFG FOR XD1 USING AVG_APPLS AUTOMATIC

SQL1013N The database alias name or database name "XD1" could not be found.

SQLSTATE=42705

CONNECT RESET

SQL1024N A database connection does not exist. SQLSTATE=08003

TERMINATE

DB20000I The TERMINATE command completed successfully.

ERROR 2011-04-23 13:53:37

MDB-01999 Error occured, first error is: <SQL1013N The database alias name or database name "XD1" could not be found.>

ERROR 2011-04-23 13:53:37

UT-03025 Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined.

ERROR 2011-04-23 13:53:37

FCO-00011 The step UpdateCfg with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_DB6_DB|ind|ind|ind|ind|1|0|NW_DB6_UpdateDbCfg|ind|ind|ind|ind|19|0|UpdateCfg was executed with status ERROR .

INFO 2011-04-23 13:54:24

An error occured and the user decide to stop.\n Current step "|NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_DB6_DB|ind|ind|ind|ind|1|0|NW_DB6_UpdateDbCfg|ind|ind|ind|ind|19|0|UpdateCfg".

Kindly suggest how to go about.

Thanks in Advance

Arun

[former_member208104]

Arun,

There may be multiple reasons for this issue

1. You may be installed more than 1 database on your system

2. Your environment variables are messed up :

3. Please checks following environment variables are set up properly:

u2022 Dbms_type = db6

u2022 DB2DBDFT = XD1

u2022 Dbs_db6_schema=sapxd1

u2022 LIB_DIRECTORY_PATH

4. Make sure your database and licensing services started

Run the following command to verify the connection status from xd1adm dos prompt

Db2 connect to XD1

If this works try to run:

R3trans u2013d command and send the log

-Sanjay