Ask Your Question
1

No parameters found for record with ID SELECT xx FROM xxx.xxx::rowCount:xx; skipping

asked 2019-12-17 17:15:34 -0600

txcs43vr gravatar image

updated 2019-12-17 17:54:41 -0600

Hi Guys, I have a pipeline moving data from Oracle to AWS/Postgres. I only move one column and the origin datatype is Number and I tried to convert to Integer and then Numeric but still have the same warning message:

"No parameters found for record with ID SELECT x FROM xx.xxx::rowCount:xx; skipping"

Hint, No data was loaded into the destination.

Table and Column Name are exactly the same on both Origin and Target

any suggestion?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2019-12-17 17:29:42 -0600

metadaddy gravatar image

Is the field name the same between Oracle and Postgres? If it is not, then you probably need to add a field-to-column mapping in the Postgres destination.

edit flag offensive delete link more

Comments

Yes, fieldName is the same

txcs43vr gravatar imagetxcs43vr ( 2019-12-17 17:36:01 -0600 )edit

The error indicates that there are no columns to write for that record. Are you trying to insert records or update?

metadaddy gravatar imagemetadaddy ( 2019-12-17 18:20:53 -0600 )edit

it's an insert I had the same pipeline moving data from postgres to postgres with no issue but when I switched to Oracle(source) it created the error

txcs43vr gravatar imagetxcs43vr ( 2019-12-17 18:28:12 -0600 )edit

And the column name in Oracle is definitely the same as in Postgres? Have you verified in preview that all is as expected?

metadaddy gravatar imagemetadaddy ( 2019-12-17 18:50:08 -0600 )edit

yes, I also have a second pair of eyes who works on this app for the last 3 months looking into it as well,

txcs43vr gravatar imagetxcs43vr ( 2019-12-17 18:56:38 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-12-17 17:15:34 -0600

Seen: 41 times

Last updated: Dec 17 '19