Skip to Content
0

BODS not able to process the rows after Query

Dec 18, 2017 at 01:18 PM

28

avatar image
Former Member

I am trying to execute a BODS job having 3 tables in the source, but i can see the data processing after Query transform ifrom 2 tables in debug mode and no data being processing in 1 query tansform .The records is around 60 k in three tables.

I have tried by creating a new job with the table where i was facing the issues and the rows are properly processed that is data is passing to the temp table.

Is this any DS issue or other technical glitch.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Arun Sasi Dec 19, 2017 at 03:30 AM
0

If your Source tables are from the same Data Source, Data Services will generate a SQL which will have the joins from the three tables. Run the SQL in Database and check what is the result.

Regards

Arun Sasi

Share
10 |10000 characters needed characters left characters exceeded