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

Error while compiling custom resource

Avatar

Avatar
Boost 1
Level 1
pp36849159
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
pp36849159
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
pp36849159
Level 1

04-10-2018

I get the following errors when trying to create a custom resource. Anyone else encountered these errors and what maybe the cause?

SOP-330011 Error while executing the method 'PublishCusResources' of service 'xtk:builder'.

WDB-200001 SQL statement 'CREATE TABLE CusRegistry_details( fITEM_RETAIL_AMT REAL NOT NULL Default 0, fITEM_SALE_AMT REAL NOT NULL Default 0, iCreatedById INTEGER NOT NULL Default 0, iMZB_PROD_ITEM_ID INTEGER NOT NULL Default 0, iMZB_STORE_ID INTEGER NOT NULL Default 0, iModifiedById INTEGER NOT NULL Default 0, iREGISTRY_LINE_ITEM_NUM INTEGER NOT NULL Default 0, iREQ_QTY INTEGER NOT NULL Default 0, iSTORE_NUM INTEGER NOT NULL Default 0, sACT_IND "char", sCLASS_SKU_UPC VARCHAR(20), sCOWORKER_NUMBER VARCHAR(10), sCREATED_ID VARCHAR(20), sREGISTRY_NUM VARCHAR(12), sSKU_IMS_NUM VARCHAR(16), sSUB_CLASS_NUM VARCHAR(8), sUPDATED_ID VARCHAR(20), tsCREATED_DT TIMESTAMPTZ, tsCreated TIMESTAMPTZ, tsLastModified TIMESTAMPTZ, tsSRC_CREATED_DT TIMESTAMPTZ, tsSRC_UPDATED_DT TIMESTAMPTZ, tsUPDATED_DT TIMESTAMPTZ )' could not be executed.

PGS-220000 PostgreSQL error: ERROR: relation "cusregistry_details" already exists

Replies

Avatar

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
Adhiyan
Employee

05-10-2018

Hello ,

This is the reason : : PGS-220000 PostgreSQL error: ERROR: relation "cusregistry_details" already exists.

Can you check if a table with the same name is already not present in the Database. Or change the name of this table to say cusregistry1 and then try.

Regards,

Adhiyan

Avatar

Avatar
Boost 1
Level 1
pp36849159
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
pp36849159
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
pp36849159
Level 1

19-10-2018

Hello ,

We are using the Cloud version of Adobe Campaign Standard. I get the same kind of errors when trying to extend the profile attributes.

1600310_pastedImage_0.png

I did not create this field earlier but every time i try publishing this it gives an error that the column already exists.

Avatar

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile
pablo_rosero1
Level 10

29-10-2018

Adhiyan

Avatar

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile
pablo_rosero1
Level 10

21-11-2018

Hi Prabha,

Did you try changing the column name or getting rid of it if not needed?

Let me know.

All the best,

Pablo