Error while congiguring config tool

[Former Member]

HI,

I tried to change the JVM settings using config tool but it is giving an error and the config tool is automatically closing.can anybody help me to resolve this problem.

Error occurred while working with Configuration.

com.sap.engine.frame.core.configuration.ConfigurationException: Error occurred during DB access: ,

at com.sap.engine.core.configuration.impl.persistence.rdbms.UpdateProcessor.flush(UpdateProcessor.java:294)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.commitConfigurationHandler(ConfigurationCache.java:1217)

at com.sap.engine.core.configuration.impl.ConfigurationHandlerImpl.commit(ConfigurationHandlerImpl.java:833)

at com.sap.engine.configtool.batch.task.ChangeInstancePropsTask.go(ChangeInstancePropsTask.java:118)

at com.sap.engine.configtool.batch.task.TasksThread.run(TasksThread.java:46)

Caused by: com.sap.dbtech.jdbc.exceptions.BatchUpdateExceptionSapDB: [-3018]: Invalid numeric parameter(input position 😎

at com.sap.dbtech.jdbc.CallableStatementSapDB.executeBatch(CallableStatementSapDB.java:608)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeBatch(DirectPreparedStatement.java:1102)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeBatch(DirectPreparedStatement.java:1066)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBAccessDefault.execUpdateEntryBatch(DBAccessDefault.java:1180)

at com.sap.engine.core.configuration.impl.persistence.rdbms.UpdateProcessor.flush(UpdateProcessor.java:261)

... 4 more

Regards,

Kiran.

[Former Member]

This error may be due to following

1) DB may not be running. So check that

2) DB Configuration on WAS is not correct. Check userid/password

Try login to DB using the SQL Client using following userid/password

SAPJ2EDB/abcd1234 (if it's sneak preview version and you haven't changed the default passowrds.

Regards,

Piyush

ps: pls mark useful answers.

[Former Member]

Is your DB running???

Thanks

Prince Jose

[former_member192029]

Hi Bhogi

1)Try with setting JAVA_HOME in system properties

2) Check the DB connection details (like URL, port, username & pwd)

Cheers

Jawahar Govindaraj