cancel
Showing results for 
Search instead for 
Did you mean: 

SSM 10 error ORA-01027 while using CubeBuilder

Former Member
0 Kudos

Hello,

I am facing an error while building a new model in SAP Strategy Management 10.0 with CubeBuilder tool. The database is Oracle 11.

I can successfully connect to \strategy\cubebuilder, create a new model, add dimension and measure, add new members to the dimension but when I press the button Build PAS model the error message is thrown with reference to the .trc file. In the tracing file I've found the Oracle error // ORA-01027: bind variables not allowed for data definition operations //.

Have you ever faced this problem and how it can be solved.

Thank you in advance.

Your feedback is very appreciated.

Best regards,

Donatas Budrys

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

more info on this issues.

Here is the content of the trace file where we can see the Oracle error message:

LSS>

LSS> set control LINKID SSM_CB_EA

LSS>

LSS> .... capture cube id in a control var to simplify queries on other tables

LSS> access lslink

LSLink> connect SSM_CB_EA

LSLink>

LSLink> select 'set control CUBEID ' || id from cpms_cb_cubes where name = 'MOFMODEL04'

LSLink> output proc setcubeid;PIPADMINDEFAULT over

LSLink> peek nohead nonumb

LSLink> output off

LSLink>

LSLink> end

LSS>

LSS> job setcubeid;PIPADMINDEFAULT

LSS> LSS>

LSS> .... start by getting FY start month and setting calendar

LSS> access lslink

LSLink> connect SSM_CB_EA

LSLink>

LSLink> select fy_start_month from cpms_cb_cubes where name = 'MOFMODEL04'

LSLink> lss create code = 'set fiscal calendar ' + fy_start_month

LSLink> output proc setfiscal;PIPADMINDEFAULT over

LSLink> peek create nohead nonumb

LSLink> output off

LSLink>

LSLink> end

LSS>

LSS> job setfiscal;PIPADMINDEFAULT

LSS> LSS>

LSS> .... build all the dimensions

LSS> job 'cb_adddims.pro'

LSS> .... cb_adddims.pro

LSS>

LSS> ..... procedure called to add and also update dimensions

LSS>

LSS>

LSS> .... temp table has info for dims in this model that is used by cb_onedim.pro

LSS> access lslink

LSLink> connect SSM_CB_EA

LSLink>

LSLink> .... should have been dropped at end of last build but doing here just in case

LSLink> drop table cpms_cbtmp1

ORA-00942: table or view does not exist



LSLink>

LSLink> begin

> create table cpms_cbtmp1 as

> select id, name, num_levels, level0 as inp,

> nvl2(level1, ',' || level1, level1) as out1,

> nvl2(level2, ',' || level2, level2) as out2,

> nvl2(level3, ',' || level3, level3) as out3,

> nvl2(level4, ',' || level4, level4) as out4,

> ' ' as result

> from cpms_cb_dims

> where  cpms_cb_cubes_id = &CUBEID

> and result = 1

> union

> select id, name, num_levels, level0 as inp,

> nvl2(level1, ',' || level1, level1) as out1,

> nvl2(level2, ',' || level2, level2) as out2,

> nvl2(level3, ',' || level3, level3) as out3,

> nvl2(level4, ',' || level4, level4) as out4,

> 'NORESULT' as result

> from cpms_cb_dims

> where  cpms_cb_cubes_id = &CUBEID

> and result = 0

> end

ORA-01027: bind variables not allowed for data definition operations



LSLink>

LSLink> select id from cpms_cbtmp1

ORA-00942: table or view does not exist



LSLink> lss create code = "job 'cb_onedim.pro' '" + id + "'"

LSLink> output proc blddims;PIPADMINDEFAULT over

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

Also I have noticed while SQL Server and DB2 procedures are different, the MaxDB and Oracle procedures are identical.

Any ideas?

Thank you in advance.

Donatas Budrys

former_member260594
Active Contributor
0 Kudos

Hello Donatas,

I am not sure about the "ORA-01027: bind variables not allowed for data definition operations" error but the first error in the trace, "ORA-00942: table or view does not exist" could suggest that you do not have access or rights to the table. Can you contact the DBA and confirm that the user has privileges to it?

Another possiblity, though remote, is that there is not enough disk space available on the server or space allocated on the database.

Regards,

Graham

Former Member
0 Kudos

Hi Donatas,

It seems the problem with link id creation.Reply with properties of the link id(SSM_CB_EA)created in PAS.

Regards

Bala

Former Member
0 Kudos

Hello, Graham,

we have checked - we have all required rights and the space on disk is enough.

Investigating further.

Thank you for your ideas.

Best regards,

Donatas Budrys

Former Member
0 Kudos

Hello, Bala,

here is the content of my LinkID.

[enable]

ConnectionID1=Oracle
(OCI)

ConnectionID2=DB2
(CLI)

ConnectionID3=SAP NW
BI RFC (using sapnwrfc.ini)

COnnectionID4=SAP NW
BI RFC (load balancing)

ConnectionID5=SAP NW
BI RFC (specific server)

ConnectionID6=SAP NW
BI RFC (using saplogon.ini)

ConnectionID7=SAP
BusinessObjects Enterprise

[ConnectionID]

ConnectionID1=SSM_CB_EA

ConnectionID2=SSM

[Settings]

LastSource=SSM_CB_EA

[SSM_CB_EA]

A0=Oracle

A1=0User
Name:=SAPSR3DB

B1=3Password:=password

C1=0Server:=192.168.0.110:1527/SJD

D1=0Library:=OCI.DLL

E1=Oracle through
the Oracle Call Interface.

E2=ORACLE

T1=Oracle (OCI)

V1=5.0.0

Q1=NO

[SSM]

A0=ODBC

A1=192.168.0.110

E1=Oracle in XE

T1=ODBC

V1=9.6.0

Please note that server IP and password were changed in the script provided above.

Thank you and waiting for your suggestions.

Best regards,

Donatas Budrys

Former Member
0 Kudos

Hi Donatas,

Please find the screenshot of my link id properties.Also reply whether your Test connection issuccessfull.

Regards

Bala

Former Member
0 Kudos

Hi, Bala,

I've compared my LinkID. The content is the same except that in Library field we have specified only OCI.DLL instead of <disk>:\<folder>\oci.dll. Our SSM system is in Linux.

Connection is successfull.

Thank you and waiting for your next ideas.

Best regards,

Donatas Budrys

Former Member
0 Kudos

Hi Donatas,

Check with your OCI.DLL file version.It should be 32 bit.

Regards

Bala

Former Member
0 Kudos

Hi, Bala,

you are completely right.

We are using Oracle 11 and at first we had general connection problems. Then we have discovered that during installation of Oracle 11 on Linux only 64-bit drivers are installed. So we manually installed 32-bit OCI.DLL and other drivers.

Now we have 32-bit Oracle drivers.

Thank you for idea.

Waiting for further feedback.

Best regards,

Donatas Budrys

Former Member
0 Kudos

Hi Donatas,

After installing your 32 bit oracle drivers.check the following procedure has done.

Delete the link id and Create it again and Mapping the 32 bit OCI.dll link in the library field and Test the Connection.

Regards

Bala

Former Member
0 Kudos

Hello, Bala,

the problem was resolved by updating the SSM 10 to the latest version.

Thank you for your efforts and help

Best regards,

Donatas

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Donatas,

Have you followed the installation guide step where you copy the files from the directory

<install-dir>\SAP BusinessObjects\Strategy Management\InternetPub\procs\oracle_procs

and paste them up one level into the directory

<install-dir>\SAP BusinessObjects\Strategy Management\InternetPub\procs\

replacing the MaxDB version of the same files?

Regards!

Ricardo

 

Former Member
0 Kudos

Hello, Ricardo,

thank you for your prompt answer.

Yes, we have copied those files and double-checked it's existence in the required folder.

Any more ideas why this error is happening?

Best regards,

Donatas Budrys