We are getting this error, when an order pending approval emails is getting sent.

[Former Member]

We moved to hybris 5.4 and testing with oracle 10.2 with ojdbc7.jar with jdk 1.7 in win 2008 r2 We are getting this error, when an order pending approval emails is getting sent.

ERROR [hybrisHTTP40] [FlexibleSearch] Flexiblesearch error: type code '"EmailAddress"' invalid ERROR [hybrisHTTP40] [FlexibleSearch] query was 'SELECT {"pk"} FROM {"EmailAddress"} WHERE {"emailAddress "} = 'myname@dummy.com'' ERROR [hybrisHTTP40] [ConnectionImpl] transaction of unbinding connection 453(-) has not been ended - will rollback automatically ERROR [hybrisHTTP8] [FlexibleSearch] Flexiblesearch error: type code '"EmailAddress"' invalid ERROR [hybrisHTTP8] [FlexibleSearch] query was 'SELECT {"pk"} FROM {"EmailAddress"} WHERE {emailAddress= 'myname@dummy.com'' ERROR [hybrisHTTP8] [ConnectionImpl] transaction of unbinding connection 453(-) has not been ended - will rollback automatically ERROR [hybrisHTTP8] [FlexibleSearch] Flexiblesearch error: cannot search unknown field 'TableField(name='"pk"',langPK='null',type=EmailAddress)' within type EmailAddress unless you disable checking , infoMap=TypeInfoMap for type = 8796127985746 code = EmailAddress

Any idea , why this issue is coming ..? Appreciate you inputs to fix ..

[Former Member]

there is settings in some DBs how table / column names are interpreted in terms of capitalization, Can you tell me where I have to check ?

[Former Member]

I remember there is settings in some DBs how table / column names are interpreted in terms of capitalization, can you check if they are correct?

Did you migrate to Oracle with this step or have you been using it before?

[Former Member]

Even I get this same issues often. I did initialize and tested , then also the same problem persists. Konrad : I have not run any migration , this issue is not found in hsql also.

Is it a known issues in hybris 5.4 ?

[Former Member]

Could you go to admin console > Console > Flexible Search > SQL Query and run:

 select * from EmailAddress

and see what you get?

And then try to run the query you posted above in the FlexibleSearch console.

It seems to me that something in the migration process went wrong with that type or that SQL table, so we should check if it is there and what is there.