error while creating a cube using Cube Builder

[Former Member]

we have installed the Cube builder for SSM 7.0

while creating the cube I am facing a error and the .TRC file contents are as follows :-

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 ID FROM CPMS_CB_CUBES WHERE NAME = 'CUBEBUILDER1'

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'CPMS_CB_CUBES'.

SQLSTATE: S0002

SQL System code: 208

LSLink> lss create code = 'set control CUBEID ' + ID

LSLink> output proc setcubeid;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

Kindly help me out........

[former_member84747 · Accepted solution]

The problem you're having with finding the CPMS_CB_CUBES table makes this issue sound like you're not using the owner of those tables in your Link ID.

In SQL Server, if you're querying the tables as anyone but the owner, you have to use OWNER.TABLENAME as the format for accessing the tables. However, because we do not know who the owner of the tables is, it will vary in every CE installation, we simply assume that you're using the owner of the tables in your Link ID, and then you will be able to query using just the tablename.

In a CE installation, the owner of the tables is usually SAP<SID>DB, for example SAPCE1DB if your SAP Instance Identifier is CE1. This is a user that is automatically created by the CE installation in SQL Server, and is the user that you need to use in your Link ID. I would recommend that you check your Link ID and see what user you are using and make sure it is the SAP<SID>DB user. If it is not, when you make that change my guess is that you will be able to successfully build the cube from Cube Builder.

Hope this helps,

Robert

[Former Member]

hi Martin

i think you better raise this question as a new thread since it will get more exposure and u can get a more number of hits and answers.

as for your problem kindly check if the master of your database is 'SAPCE1ADM' or something else. i made a similar mistake and got it corrected now. Plus kindly create an ODBC connection and check your system DSN both at the server side and your PC side as well and ensure you have the required drivers.

hope this helps

Vijay.

[Former Member]

Hi,

I have changed the lslink to use the user SAPCE1ADM.

After this, I get following error, when building a new CUBE in cubebuilder.

But the model connections; "CBSYS2_MM" and "CBSYS2_SC" are ceated.

In PAS I can see the SYS2 DB, but no measures are attached.

I am using MsSQL.

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 ID FROM CPMS_CB_CUBES WHERE NAME = 'SYS2'
LSLink> lss create code = 'set control CUBEID ' + ID
LSLink> output proc setcubeid;PIPADMINDEFAULT over
LSLink> peek create nohead nonumb
ACC089:
Unable to Find ID for CREATED Field CODE
ACC089:
Unable to Find ID for CREATED Field CODE
LSLink> output off
LSLink> 
LSLink> end
LSS> 
LSS> job setcubeid;PIPADMINDEFAULT
LSS> ACC089:
ACC089:
^
Expected an Application Server Command
CHE FRE
CHE UPD

Please help

Martin Bille

[former_member84747]

Hi Martin,

I believe that the issue you are encountering now is that you're using the wrong set of procedures for accessing MS SQL Server.

In section 5.4.1 (Setting up SAP NetWeaver System database software) in the Strategy Management configuration guide, there is a section which discusses steps that are required depending on whether or not you are using MaxDB or MS SQL Server as your system database behind NetWeaver CE. My guess is that you have not followed the steps described for SQL Server here. This is simple to do thoughm, because all you need to do is copy the files in the "<install-dir>\SAP\SSM\InternetPub\procs\sqlsrvr_procs" into the <install-dir>\SAP\SSM\InternetPub\procs" directory.

This is required because, when using Cube Builder or Entry and Appropval, the PAS component communicates directly with the system database in order to load data from there into PAS. Because MaxDB and SQL Server have different SQL syntax, specifically regarding field concatenation, slightly different SQL is required. So if you copy the SQL Server specific procedures across, you should be able to successfully build your model from Cube Builder.

Of course, having read through your question again I'm not 100% sure that this is what you are hitting. The problem you're seeing seems to be that, when we internally concatenate some selected fields together, we aren't finding a field called ID. However, the SQL select being issued doesn't seem to have returned any error messages, so I'm not sure why there is a problem referencing the field.

The only thing that comes to mind is a problem that I ran into at one point with the type of driver I was using to connect to SQL Server. The PAS component of Strategy Management, even though it runs on Windows 2003 Server 64bit, is still only a 32bit component. This means that, when configuring the System Data Sources within the ODBC applet in Control Panel, it is critical that the 32bit version of that ODBC applet be used - as documented in the note at the end of section 5.4.3 in the configuration guide. The reason this is important is because, if you use an OLEDB connection to SQL Server, for some reason the field names are not returned correctly. It is only when using the ODBC driver that the field names are returned correctly.

So please ensure that you are using the ODBC driver for your Link ID which connects to SQL Server, and not an OLEDB connection.

Hope this helps,

Robert

Edited by: Robert Holland on Dec 19, 2008 3:23 PM

[Former Member]

Hi Vijay,

It seems an ODBC error.

Did you create the ssm_cb_ea link ID which is explained in section 5.4.3 of the Server Configuration Guide?

Kind regards,

Santiago

[Former Member]

we have created that link as per the instructions given in the Configuration guide.

Edited by: vijay kumar on Dec 10, 2008 6:49 AM

[Bob_McGlynn]

Vijay,

Were you able to successfully test your LinkID connention in PAS? You may want to check to your SQLServer ODBC connections too.

Regards,

Bob