Expand my Community achievements bar.

OOB Schema Issue - Nms:CouponValues

Avatar

Level 3

Dear All, Need your help here. We couldn’t find the out of the box column values in nms : couponValues schema structure.
It is properly fetching the columns in DEV region but we are facing the issue in PROD due to this workflows are failing.

Is there a way to reload this nms schema? since it is OOB we couldn't experiment much, Please assist.

Thank you!

DEV - It is workingDEV - It is workingPROD - It is not fetching the columnsPROD - It is not fetching the columnsPROD - Column Defined in SchemaPROD - Column Defined in Schema

 

dobe sufficient; be adequate, either in quality or quantityMore (Definitions, Synonyms, Translation)

9 Replies

Avatar

Level 5

Hi @ukender , 

 

If this is On premise, then please see to the coupon values table ; if you have the first record with empty value. 

Also , try to regenerate the schema if you can. 

 

Thanks,
Adithya

Avatar

Level 3
Hi Adithya - Thanks for the response. Yes - It is on-premise. Could you pls help me how to regenerate the schemas? Thank you!

Avatar

Level 5

Hi Ukender- You can always regenerate the schema's , but before make sure you have backed up the schema with the updated information.

adithyacs86_0-1611067777688.png

 

Avatar

Level 3

Hi Adithya - Thank you, I have tried to regenerate the schema but it didn't work. Also there is no null value in the table. Is there any other way to refresh the schema? Thank you!

 

Avatar

Level 5
Hi Ukender, Yes this Null value will be used for the joins from the coupons to coupon values table.. so my guess is to remove the coupon and then regenerate the table.

Avatar

Level 3

Hi Adithya - Thanks for the suggestion, regenerated both coupon & couponValue schemas. Still the columns are not reflecting in couponValue schema.
Also, I couldn't find the CouponValue schema in the wizard. Please assist,.

ukender_0-1611126831874.png

 

Thank you!

 

fetchedthe action of fetchingMore (Definitions, Synonyms, Translation)

 

 

 

Avatar

Administrator
Hi @adithyacs86, Can you please help @ukender further? Thanks!


Sukrity Wadhwa

Avatar

Level 5
Hi , Not much.. I could say check the versions of the build used in production and in your QA. Please raise the concern with Adobe. If possible check the .sql file which contains the couponValues table name in the DDL folder

Avatar

Level 4

Hi @ukender ,

Was the issue resolved? It would be helpful if you could please share the workaround or solution. I am also facing the same issue, build version 9032.

Thanks in advance!