Replies posted by Chris Macomber
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,
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.
Already have an account? Login
Login to the community
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.