To GoodData homepage

Replies posted by Chris Macomber

5 Replies

C
Chris MacomberParticipating Frequently
asked in Data models

Error when loading data into column that's not in the data model

Thank you in advance for the potential help, Jan.  We’re reading Hubspot data from a warehouse we’ve built.  They have an hs_deal table with all the deals in the CRM.  There are columns in that table to track the time spent in each stage of the CRM’s pipeline, and one of those columns is called “hs_deal.property_hs_time_in_1105203”.  However, I’ve removed the fact corresponding to that column from the data model, but the load is still throwing an error, “SQLSTATE_NUMERIC_VALUE_OUT_OF_RANGE. Details: numeric field overflow: 20120646217.0'.” I’ve attached the run log in case it helps too.

8
C
2 years ago
C
Chris MacomberParticipating Frequently
asked in Data models

Error when loading data into column that's not in the data model

Thank you Moises.  I go to the gray pages, but it asks for a login, and my GoodData credentials are getting rejected.  Is there a different account I need to setup to access the gray pages?  

8
C
2 years ago
C
Chris MacomberParticipating Frequently
asked in Data models

Error when loading data into column that's not in the data model

Moises, I was able to login and removed some cols using MAQL, but now getting this error when loading data.  I looked in the metadata, but there’s no attribute with id 27658 (first one in the list) for example. 2022-03-09T22:15:48.194+0100 [WARN]: Project "xyp336qpoai0p3fqmra8xrbkwpmnk9u5" was not integrated. Reason: Non-synchronized dataset "dataset.hs_deal/28360", identified unused columns "27658,27646,27534,27770,27448,27844,27812,27408,2163,27484,27710,27634,27560,27454,27750,27836,27556,27590,27904,27720,27764,27854,27398,27506,27866,27772,27422,27896,27768,27662,27706,27804,2181,27504,27636,27524,27610,27682,27780,27450,27404,27652,27614,27782,27618,27558,27698,27890,27474,27824,27508,27578,27648,27766,27876,27498,27814,27718,27604,27678,27452,27548,27406,27740,27414,27532,27838,27848,27676,27714,27458,27522,27460,27462,27688,27724,27722,27738,27576,27732,27834,27670,27700,27674,27756,27882,27496,27774,27514,27482,27716,27464,27410,27638,27680,27778,27754,27906,27694,27490,27612,

8
C
2 years ago
C
Chris MacomberParticipating Frequently
asked in Data models

Error when loading data into column that's not in the data model

Thank you, that worked!

8
C
2 years ago
C
Chris MacomberParticipating Frequently
asked in Metrics and MAQL

When validating project, getting errors stating "...violates COMPULSORY EDGE..."

Hello Daniela,I ran SYNCHRONIZE and we’re still getting the same exact errors.

3
D
GoodData Employee
2 years ago
Welcome to the GoodData Community!Cookie settings