Skip to Content
author's profile photo Former Member
Former Member

BODS And Rapid Mart- Data Model Job Only Creates 9 Tables Before Running Into a Syntax Error.

Hello Experts,

I am in the process of installing the Sales Rapidmart on an Enterprise Evaluation Version of SQL 2008 R2 DB.

I am using version 4.1 of Data Services, and 4.0 Of the Sales Rapidmart.

The current behavior I am experiencing is the following; When executing the Rapidmart_Data_model Job, the job will get to the DF_Create_Table_SAP step in the job, It will only create the 9 first tables. After creating the ACTIVITY_HIER_BAD table, the next table the job should create is the ACTIVITY_HIER_BAD_HZ table, however, the job crashes on this step and we get a vague syntax error message that states "Syntax Error Near ',' " which is not entirely descriptive.

Has anybody Experienced a similar type of behavior where the Rapidmart_datamodel_job only creates the first few tables before throwing an error? If so, what steps did you take to get this resolved?

Any and all help will be extremely appreciated.

Thank You.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jan 03, 2014 at 11:53 PM

    Hi,

    Use this sql this may help you and change data types as your requirement.

    sql ( 'RM_DS', 'CREATE TABLE COMPANY_CODE ( CLIENT_ID int PRIMARY KEY,LANG_ID_MULTI int,CMPNY_CODE_ID int)' );

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 03, 2014 at 04:32 PM

    In Addition, this is the current error we are commonly running into:

    DBS-070401: |Data flow DF_TableCreate_SAP|Transform Qry_Create_Table ODBC data source <NAUSSAP04\MSSQLSERVER_EVAL> error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ','.>.

    (12072:12284) RUN-050304: |Data flow DF_TableCreate_SAP|Transform Qry_Create_Table|Function FN_Create_Table Function call <sql ( RM_DS, CREATE TABLE DBO.ADDRESS (, PRIMARY KEY ( CLIENT_ID,ADDRESS_KEY )) ) > failed, due to error <70401>: <ODBC data source <NAUSSAP04\MSSQLSERVER_EVAL> error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ','.>.>.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.