cancel
Showing results for 
Search instead for 
Did you mean: 

Error while creating database instance during PI instalation

anand_sampath2
Participant
0 Kudos

Hi Team,



I am in the installation phase of SAP PI with MAXDB as back end.In the

phase "create database instance" i am facing the following issue

"An error occurred while processing option SAP EHP1 for SAP NetWeaver

PI/Mobile/Banking 7.1 > MaxDB > SAP Systems > Process Integration >

Standard System > Standard System( Last error reported by the step:

Error during execution of command identifier 'ACTIVATE'"

Can you help me in resolving this issue at the earliest.Also i have attached

the sapinst_dev log filke in this incident along with the

error screenshot

Thanks,

Satheesh E

Accepted Solutions (1)

Accepted Solutions (1)

anand_sampath2
Participant
0 Kudos

Target node does not exist and (mode & ISyNode::MISSING) ==> I will copy/move.

TRACE      2014-09-08 16:31:08.874 [syxxcnode.cpp:425]

           CSyNodeImpl::move(const CSyPath & C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS/__instana_tmp.1.xml, ISyNode::CopyMoveMode_t 0x3)

           lib=syslib module=syslib

Moved C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS/__instana_tmp.xml to C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS/__instana_tmp.1.xml

INFO       2014-09-08 16:31:08.905 [synxcpath.cpp:799]

           CSyPath::createFile() lib=syslib module=syslib

Creating file C:\Program Files\sapinst_instdir\NW711\ADA\INSTALL\STD\AS\__instana_tmp.xml.

TRACE      2014-09-08 16:31:10.796 [cstatisticmanager.cpp:2241]

           CStatisticManager::writeInstallationSlanaFile_Intern

TRACE      2014-09-08 16:31:10.811 [syxxcfile.cpp:85]

           CSyFileImpl::decideIfMoveCopyNode(const CopyMoveDestinationInfo & {m_nodeTypeForCombiCheck: ..., m_path: C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS/instslana.1.xml, m_realNodeType: 8}, ISyNode::CopyMoveMode_t 0x3, PSyNodeInt &) const 

           lib=syslib module=syslib

Target node does not exist and (mode & ISyNode::MISSING) ==> I will copy/move.

TRACE      2014-09-08 16:31:10.811 [syxxcnode.cpp:425]

           CSyNodeImpl::move(const CSyPath & C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS/instslana.1.xml, ISyNode::CopyMoveMode_t 0x3)

           lib=syslib module=syslib

Moved C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS/instslana.xml to C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS/instslana.1.xml

INFO       2014-09-08 16:31:10.811 [synxcfile.cpp:149]

           CSyFileImpl::removeEx(ISyFSErrorHandler * pErrorHandler)

           lib=syslib module=syslib

Removed file C:\Program Files\sapinst_instdir\NW711\ADA\INSTALL\STD\AS\instslana.xml.

INFO       2014-09-08 16:31:10.811 [synxcpath.cpp:799]

           CSyPath::createFile() lib=syslib module=syslib

Creating file C:\Program Files\sapinst_instdir\NW711\ADA\INSTALL\STD\AS\instslana.xml.

TRACE      2014-09-08 16:31:10.889

SAPInst calls the LogInquirer. The output of the LogInquirer can be found in file sapinst_loginquirer.log.

TRACE      2014-09-08 16:31:15.669 [iaxxgenimp.cpp:638]

            CGuiEngineImp::showMessageBox()

<html> <head> </head> <body> <p> An error occurred while processing option <i>SAP EHP1 for SAP NetWeaver PI/Mobile/Banking 7.1 > MaxDB > SAP Systems > Process Integration > Standard System > Standard System( Last error reported by the step: Error during execution of command identifier 'ACTIVATE' : <DBMException -24988 ERR_SQL SQL error

-2014,Identifier too long>)</i>. You can now: </p> <ul> <li> Choose <i>Retry</i><br>to repeat the current step. </li> <li> Choose <i>Log Files</i><br>to get more information about the error. </li> <li> Stop the option and continue later. </li> </ul> <p> Log files are written to C:\Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS. </p> </body></html>

TRACE      2014-09-08 16:31:15.669 [iaxxgenimp.cpp:1031]

           CGuiEngineImp::acceptAnswerForBlockingRequest

Waiting for an answer from GUI

INFO       2014-09-08 16:31:19.434 [sixxcstepexecute.cpp:1002]

An error occurred and the user decided to retry the current step: &quot;|NW_Doublestack_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_CreateDB|ind|ind|ind|ind|createdb|0|NW_ADA_DB|ind|ind|ind|ind|nw_ada_db|0|SdbPreInstanceDialogs|ind|ind|ind|ind|preinstance_dialogs|0|SdbInstanceDialogs|ind|ind|ind|ind|instance_dialogs|0|SDB_INSTANCE_CREATE|ind|ind|ind|ind|instance_create|0|sdb_instance_activate&quot;.

INFO       2014-09-08 16:31:19.450 [synxccuren.cpp:887]

           CSyCurrentProcessEnvironmentImpl::setWorkingDirectory(const CSyPath & C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS)

           lib=syslib module=syslib

Working directory changed to C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS.

TRACE      2014-09-08 16:31:19.465 [syxxcfile.cpp:85]

           CSyFileImpl::decideIfMoveCopyNode(const CopyMoveDestinationInfo & {m_nodeTypeForCombiCheck: ..., m_path: C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS/stepLogMessages.2.xml, m_realNodeType: 8}, ISyNode::CopyMoveMode_t 0x3, PSyNodeInt &) const 

           lib=syslib module=syslib

Target node does not exist and (mode & ISyNode::MISSING) ==> I will copy/move.

TRACE      2014-09-08 16:31:19.465 [syxxcnode.cpp:425]

           CSyNodeImpl::move(const CSyPath & C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS/stepLogMessages.2.xml, ISyNode::CopyMoveMode_t 0x3)

           lib=syslib module=syslib

Moved C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS/stepLogMessages.xml to C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS/stepLogMessages.2.xml

TRACE      2014-09-08 16:31:19.497

Instantiating new NWUsageTypeBasic

TRACE      2014-09-08 16:31:19.497

NWUsageTypeBasic() done

TRACE      2014-09-08 16:31:19.497

  Call block: SDB_INSTANCE_CREATE_ind_ind_ind_ind

    function: SDB_INSTANCE_CREATE_ind_ind_ind_ind_PreStepPhase_sdb_instance_activate_Preprocess

is validator: false

TRACE      2014-09-08 16:31:19.543 [sixxcstepexecute.cpp:839]

Execution of preprocess block of |NW_Doublestack_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_CreateDB|ind|ind|ind|ind|createdb|0|NW_ADA_DB|ind|ind|ind|ind|nw_ada_db|0|SdbPreInstanceDialogs|ind|ind|ind|ind|preinstance_dialogs|0|SdbInstanceDialogs|ind|ind|ind|ind|instance_dialogs|0|SDB_INSTANCE_CREATE|ind|ind|ind|ind|instance_create|0|sdb_instance_activate returns TRUE

TRACE      2014-09-08 16:31:19.575

Instantiating new NWUsageTypeBasic

TRACE      2014-09-08 16:31:19.575

NWUsageTypeBasic() done

TRACE      2014-09-08 16:31:19.575

  Call block: SDB_INSTANCE_CREATE_ind_ind_ind_ind

    function: SDB_INSTANCE_CREATE_ind_ind_ind_ind_PreStepPhase_sdb_instance_activate

is validator: false

TRACE      2014-09-08 16:31:19.621

WorkDir: C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS

TRACE      2014-09-08 16:31:19.621

SdbOperations.callSdbCmdJar() Use java home : C:/Users/EGSAPI~1/AppData/Local/Temp/sapinst_exe.4716.1410173586/jre

TRACE      2014-09-08 16:31:19.637

SDB invoking java call:

C:\Users\EGSAPI~1\AppData\Local\Temp\sapinst_exe.4716.1410173586\jre\bin\java.exe -classpath "C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS\sdb_sl_lib.jar;C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS\sdb_sl_lib_api.jar;C:/Program Files/sapinst_instdir/NW711/ADA/INSTALL/STD/AS\sdb_core.jar" com.sap.sdb.core.main.cmd.SdbCmdMain

TRACE      2014-09-08 16:31:19.637 [synxcchapp.cpp:275]

           CSyChildApplicationImpl::doStart() lib=syslib module=syslib

Going to call CreateProcess/CreateProcessAsUser for 'C:\Users\EGSAPI~1\AppData\Local\Temp\sapinst_exe.4716.1410173586\jre\bin\java.exe' now.

TRACE      2014-09-08 16:31:19.637 [synxcchapp.cpp:575]

           CSyChildApplicationImpl::doStart() lib=syslib module=syslib

Trying to start C:\Users\EGSAPI~1\AppData\Local\Temp\sapinst_exe.4716.1410173586\jre\bin\java.exe CSySysLibCallsWrapper::syscallwrapper()->__CreateProcess__(NULL, <command line for executable C:\Users\EGSAPI~1\AppData\Local\Temp\sapinst_exe.4716.1410173586\jre\bin\java.exe, NULL, NULL, TRUE, 0x420, NULL, NULL, &StartupInfo, &ProcessInfo)

TRACE      2014-09-08 16:31:19.637 [synxcchapp.cpp:653]

           CSyChildApplicationImpl::doStart() lib=syslib module=syslib

A child process has been started. Pid = 4956. Executable name: C:\Users\EGSAPI~1\AppData\Local\Temp\sapinst_exe.4716.1410173586\jre\bin\java.exe

TRACE      2014-09-08 16:31:19.637

david_liu1
Advisor
Advisor
0 Kudos

Hello,

The error -2014,Identifier too long, one possible reason could be an invalid passord for

database users.

You need to check that the used passwords for database users are no longer than 8 characters.

Regards,

David

anand_sampath2
Participant
0 Kudos

Thanks . Issue got solved .

Answers (0)