Service desk installation.

[rkalidh87]

Hi,

 

am installing 12.5 in solaris sparc oracle environment and am getting below error while installation. please help to fix this.

[Anon Anon]

Hi Kalidh,

 

Try to run the command sqlplus user/password@ServiceName to see if it connects,

 

Thanks,

Naveen

[rkalidh87]

Hi Naveen,

 

Am able to connect the same from local machine as well as server, but still getting same error. please help.

 

[Alexander Perretti]

Did you make sure to set the variables as documented in the Implementation Guide?

 

Oracle Environment Variables

Set the Oracle environment variables before you install or migrate CA SDM, as follows:

■

Verify that the ORACLE_HOME variable is set correctly.

Important!

You must export TWO_TASK variable when Oracle 32 bit client variables

are exported on non-windows.

■

Include the 32-bit Oracle libraries (commonly $ORACLE_HOME/lib32 for 64-bit

Oracle) in the library path variable LD_LIBRARY_PATH (LIBPATH on AIX).

[rkalidh87]

Hi Alex,

 

I have set all paths,  but i think root user should be able  to connect

sql  plus  which  is not workinng  in my

Case. Pls help  me  to  fix  this.

On Oct 29, 2014 9:37 PM, "Alex_Perretti" <

[Raghu Rudraraju]

Maybe this doc helps? TEC609083    http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec609083.aspx

[Chi Chen]

I think this is the post we chatted earlier today.

Like we discussed earlier on, you would need to modify root's

profile to have those env variables set. You can take a look

at oracle id's profile or refer to the tech doc tec609083 for some

examples. Also make sure you install SDM as root id not

su oracle.

[rkalidh87]

Hi,

 

Please let me know how to uninstall SDM 12.5 manually, please help.

[rkalidh87]

Hi,

 

While installing SDM 12.5, tasks failed at validate extension tables end and below is the log  in configure.log file. please help me to fix this.

 

10/30 15:36:17.855 INFO  Task.java              214 Running: Validate Extension Tables

10/30 15:36:17.855 INFO  CheckExtensionTables.java   181 Starting CheckExtensionTables

10/30 15:36:17.863 INFO  ProcessUtilities.java   401 Executing command: pdm_sql "SELECT COUNT(TABLE_NAME) AS COLCOUNT FROM USER_TAB_COLS WHERE TABLE_NAME IN ('USP_PROJEX') AND COLUMN_NAME = 'EXT_ASSET'"

10/30 15:36:17.945 ERROR CheckExtensionTables.java   275

10/30 15:36:18.405 ERROR CheckExtensionTables.java   275 LOGGER:  <null log directory>  NX_LOG variable is not set  log library can't function

10/30 15:36:18.657 INFO  ProcessUtilities.java   572 Process /opt/CA/ServiceDeskManager/bin/pdm_sql completed with exit code 6

10/30 15:36:18.659 ERROR CheckExtensionTables.java   217 An unexpected error occurred check state of Extension Tables.

See configure.log for additional details.

10/30 15:36:18.660 INFO  CheckExtensionTables.java   227 CheckExtensionTables complete

10/30 15:36:18.661 INFO  Task.java              276 retCode 99999: An unexpected error occurred check state of Extension Tables.

See configure.log for additional details.

10/30 15:36:18.663 WARN  TaskMediator.java      220 Validate Extension Tables: Task failed (Validate Extension Tables).  Continue?

An unexpected error occurred check state of Extension Tables.

See configure.log for additional details.

10/30 15:36:40.466 INFO  Task.java              214 Running: Applying patches

10/30 15:36:40.474 INFO  ProcessUtilities.java   401 Executing command: orcl_check_db -c  -s SPECTRUM

10/30 15:36:40.844 INFO  ProcessUtilities.java   572 Process /opt/CA/ServiceDeskManager/bin/orcl_check_db completed with exit code 99

10/30 15:36:40.845 ERROR PatchDatabaseTask.java   449 Can't connect to the database.

[Raghu Rudraraju]

From the same shell where you ran pdm_configure try this

pdm_sql "SELECT COUNT(TABLE_NAME) AS COLCOUNT FROM USER_TAB_COLS WHERE TABLE_NAME IN ('USP_PROJEX') AND COLUMN_NAME = 'EXT_ASSET'" 

What do you get ?

Also output of command: env > env.txt and upload that file here. 

It maybe better for a support issue for this too for them to help. 

_R

[rkalidh87]

Hi Raghu,

 

Below is the output while running the above command. It gives " NX_KEY wasn't in the environment" as output.

 

please help.

 

[Raghu Rudraraju]

This basically indicates that NX_ROOT  environment variable is not defined properly, or  $NX_ROOT/NX.env  doesn’t exist (which maybe OK  because pdm_configure did not run fully yet….)

 

However, I still believe that the shell environment is not suiting the needs as the previous techdoc I mentioned.

 

_R

[rkalidh87]

Hi,

 

While installing SD, it is asking path for SD manager and tomcat services,

i gave two diff paths instead of default path. Will it cause issues and any

more files to be modified?  I have this kind of setup in production.

On Oct 30, 2014 7:17 PM, "Raghu.Rudraraju" <

[Raghu Rudraraju]

Even if you install Service Desk to  /folder1/path/ServiceDesk,    there’ll always be a link  /opt/CAisd   which will point that directory where SDM is really installed.

 

_R

[rkalidh87]

Hi,

 

I have removed SD from server and performed a fresh installation by clicking the default path for both SD and Tomcat.

 

By now am getting new errors in configure.log file.

 

Validate Extension Tables

10/31 12:33:34.722 INFO  CheckExtensionTables.java   181 Starting CheckExtensionTables

10/31 12:33:34.730 INFO  ProcessUtilities.java   401 Executing command: pdm_sql "SELECT COUNT(TABLE_NAME) AS COLCOUNT FROM USER_TAB_COLS WHERE TABLE_NAME IN ('USP_PROJEX') AND COLUMN_NAME = 'EXT_ASSET'"

10/31 12:33:34.819 ERROR CheckExtensionTables.java   275

10/31 12:33:35.295 ERROR CheckExtensionTables.java   275 LOGGER:  <null log directory>  NX_LOG variable is not set  log library can't function

10/31 12:33:35.547 INFO  ProcessUtilities.java   572 Process /opt/CA/ServiceDeskManager/bin/pdm_sql completed with exit code 6

10/31 12:33:35.549 ERROR CheckExtensionTables.java   217 An unexpected error occurred check state of Extension Tables.

See configure.log for additional details.

10/31 12:33:35.550 INFO  CheckExtensionTables.java   227 CheckExtensionTables complete

10/31 12:33:35.552 INFO  Task.java              276 retCode 99999: An unexpected error occurred check state of Extension Tables.

See configure.log for additional details.

10/31 12:33:35.553 WARN  TaskMediator.java      220 Validate Extension Tables: Task failed (Validate Extension Tables).  Continue?

An unexpected error occurred check state of Extension Tables.

See configure.log for additional details.