nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DD Error selecting the rows

ShashankJain

Hi Guys,

I want you to help in the problem i am facing. While trying to add replicant rows to the database it is throwing me the error while selecting the rows.
If I remove PRODTYPE_ID column then it works fine ,as all the other columns are not replicant.
I am attaching my DCT,DD logs,dd_config.xml.

Find more posts tagged with

Comments

Adam Stoller

You did see this error right?

...
DBD: SelectCurrentRowsELECT BREAD_CRUMB_NAME,URL,HEADING,SUBHEADING ,DESCRIPTION,ENABLED,LOCALE,PAGE_TITLE,KEYWORDS,TO_CHAR(CREATION_DATE,'MM/DD/YYYY HH24:MIS') AS CREATION_DATE,TO_CHAR(LAST_UPDATE,'MM/DD/YYYY HH24:MIS') AS LAST_UPDATE,FILE_PATH,BG_IMAGE,PAGE_DESCRIPTION,ID FROM FBRZ_BUYNOW WHERE ID IN (? )  ORDER BY  ID
DBD: Index: 1, value: 36042
DBD: Column SUBHEADING  not found in array
DBD: ERRORQLException while selecting rows from table: Invalid column name
DBD: ERROR:Error occured while selecting current rows.
...

Double check your DB schema / table definitions and see if there is a column named "SUBHEADING" in there...

ShashankJain

Hi Ghoti,

I was expecting your reply , i had seen this error and have double checked the DB schema to exactly map everything correctly in the DD descriptor file.
If I remove this Prodtype_ID from table and scriptor , it works fine.
I think there is some problem while entering the replicant column.

Can you please share any pointers?

Adam Stoller

Hi Ghoti,

I was expecting your reply , i had seen this error and have double checked the DB schema to exactly map everything correctly in the DD descriptor file.
If I remove this Prodtype_ID from table and scriptor , it works fine.
I think there is some problem while entering the replicant column.

Can you please share any pointers?

Without looking at it and playing with it - I'm not sure - but I don't like the error message that I highlighted and which seems to be at odds with what you're seeing.

thatfish

Looks like a typo in the dd cfg.


DBD: SelectCurrentRowsELECT BREAD_CRUMB_NAME,URL,HEADING,SUBHEADING ,DESCRIPTION,ENABLED,LOCALE,PAGE_TITLE,KEYWORDS,TO  _CHAR(CREATION_DATE,'MM/DD/YYYY HH24:MIS') AS CREATION_DATE,TO_CHAR(LAST_UPDATE,'MM/DD/YYYY HH24:MIS') AS LAST_UPDATE,FILE_PATH,BG_IMAGE,PAGE_DESCRIPTION,ID   FROM FBRZ_BUYNOW WHERE ID IN (? )  ORDER BY  ID

You have a space character in the dd configuration "SUBHEADING ".

ShashankJain

Looks like a typo in the dd cfg.


DBD: SelectCurrentRowsELECT BREAD_CRUMB_NAME,URL,HEADING,SUBHEADING ,DESCRIPTION,ENABLED,LOCALE,PAGE_TITLE,KEYWORDS,TO  _CHAR(CREATION_DATE,'MM/DD/YYYY HH24:MIS') AS CREATION_DATE,TO_CHAR(LAST_UPDATE,'MM/DD/YYYY HH24:MIS') AS LAST_UPDATE,FILE_PATH,BG_IMAGE,PAGE_DESCRIPTION,ID   FROM FBRZ_BUYNOW WHERE ID IN (? )  ORDER BY  ID

You have a space character in the dd configuration "SUBHEADING ".

Nope. it was not the issue, when i eliminate replicant field it works fine.