Skip to Content

Using Entry&Approval with MAXDB database

Hi all,

I'm trying to use the Entry&Approval module of SSM, but I'm getting into some problems that maybe someone can help me. I'm using SSM7.5 SP6 with MAXDB as my system database.

I already create my PAS database, I create the metric sets, I put some data there, but when I try to load the data into PAS database I get this error in the trace file:

LSS>

LSS> ... WFMDE_SETUP.PRO FOR MAXDB

LSS>

LSS> output REVIEW_LOAD;SAMPLE over

LSS> echo LOADSTARTED

LOADSTARTED

LSS> output off

LSS>

LSS> checkpoint update

LSS> checkpoint freeze

LSS>

LSS> set control WFMDELINK SSM_CB_EA

LSS>

LSS> access lslink

LSLink> connect SSM_CB_EA

LSLink>

LSLink> ... clear the scorecard status table

LSLink> begin

> DELETE FROM CPMS_SCORE_STATUS

> WHERE CPMS_CONTEXT_ID IN (SELECT ID FROM CPMS_CONTEXT

> WHERE CONTEXT_NAME IN (SELECT CONTEXT FROM CPMS_PASUSER

> WHERE UPPER(USEDB) = UPPER('SAMPLE')))

> end

[SAP AG][SQLOD32 DLL][SAP DB] Base table not found;-4004 POS(13) Unknown table name:CPMS_SCORE_STATUS

SQLSTATE: S0002

SQL System code: -4004

LSLink>

LSLink> ... create the LOADALL proc that will run wfmde_load.pro once for each content set

LSLink> begin

> SELECT DISTINCT CPMS_EA_MASTER_ID

> FROM CPMS_EA_DETAIL

> WHERE ID IN

> (

> SELECT DISTINCT CPMS_EA_DETAIL_ID

> FROM CPMS_EA_DATA, CPMS_EA_CUBES

> WHERE CPMS_EA_DATA.CPMS_EA_CUBES_ID = CPMS_EA_CUBES.ID

> AND UPPER(CUBE_NAME) = 'SAMPLE'

> )

> end

[SAP AG][SQLOD32 DLL][SAP DB] Base table not found;-4004 POS(108) Unknown table name:CPMS_EA_DATA

SQLSTATE: S0002

SQL System code: -4004

LSLink>

+LSLink> lss create code = "job 'wfmde_load.pro' '" + CPMS_EA_MASTER_ID + "'"+

LSLink> output proc LOADALL;PIPADMINDEFAULT

LSLink> peek create nohead nonumb

No Fields currently Selected

ACC004:

No Record Has Been Accessed From the Database.

ACC004:

No Record Has Been Accessed From the Database.

CHE FRE

CHE UPD

In PAS I create the linkid ssm_cb_ea pointing to DB3 MAXDB database. I also try for the MAXDB1 database, but the same result

[http://img713.imageshack.us/img713/8611/72008201.jpg]

Looks like some tables are missing !?!?!? Did I do any mistake?

Thanks in advance for all the help

Pedro

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Sep 17, 2010 at 01:27 PM

    Pedro,

    If you go to <Drive>:\Windows and check you lsserver.ini file. In that file it shows the pathway and check to make sure that your DBPATH is correct.

    Switching between dbs has more considerations than changing the Link Id. And using dbs other than Maxdb requires changing some files in the procs directories as well.

    Regards,

    Bob

    Add comment
    10|10000 characters needed characters exceeded