Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

OOB Schema Issue - Nms:CouponValues

ukender
Level 2
Level 2

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)

8 Replies
adithyacs86
Level 5
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

ukender
Level 2
Level 2
Hi Adithya - Thanks for the response. Yes - It is on-premise. Could you pls help me how to regenerate the schemas? Thank you!
adithyacs86
Level 5
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

 

ukender
Level 2
Level 2

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!

 

adithyacs86
Level 5
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.
ukender
Level 2
Level 2

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)

 

 

 

adithyacs86
Level 5
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