SQLException in (skuid)

  • 1
  • Problem
  • Updated 2 weeks ago
  • Solved
  • (Edited)
SQLException in (skuid) error when previewing a page.

Production environment functions correctly. I copied the XML to a sandbox and cannot preview the page. Receiving the above error. I've never seen this error before. Thoughts?

Other pages function fine. But this exact replica from our PROD instance isn't.
Photo of Joe Lagorio

Joe Lagorio

  • 344 Points 250 badge 2x thumb

Posted 2 years ago

  • 1
Photo of Mark DeSimone

Mark DeSimone, Official Rep

  • 11,050 Points 10k badge 2x thumb
Hi Joe. Would you be able to share the complete console message that you're seeing?
Photo of Joe Lagorio

Joe Lagorio

  • 344 Points 250 badge 2x thumb
Prod instance (page loads fine)


Sandbox instance (page doesn't load)
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
Joe,

What is the SQL Exception that you're getting?
Photo of Joe Lagorio

Joe Lagorio

  • 344 Points 250 badge 2x thumb
How do I locate this? 
Photo of Mark DeSimone

Mark DeSimone, Official Rep

  • 11,040 Points 10k badge 2x thumb
Usually, when an error pops up in red on a Skuid page, you can click to see more details. 

I'm also wondering - it looks like your prod environment may be connecting to an external data source (in your screenshot, the console reads "Congratulations! you're connected to the WAMP server."). Is that WAMP connection also set up on your sandbox? I'm wondering if there's some attribute that's not replicated in the sandbox (like org ID, for example) that's causing connection to the data source to fail.
(Edited)
Photo of Joe Lagorio

Joe Lagorio

  • 344 Points 250 badge 2x thumb
No error, just this. 

Both instances connect to multiple external data sources, the prod connections route to prod data sources and the sandbox connections route to sandbox data sources. As a side note: This full sandbox was recently refreshed so the data is very very similar. 


The issue is only for this page. All other pages are functioning correctly. I'm clueless about this.
Photo of Andrew Hess

Andrew Hess

  • 262 Points 250 badge 2x thumb
I'm having a similar issue. When I view the page on its own, I see the generic SQL Exception. But when I have the page hosted on a VF page, I get this error:

SQLException in Class.skuid.Utils.LoadModelUnserialized: line 3527, column 1 Class.skuid.Utils.LoadModelUnserialized: line 3151, column 1 Class.skuid.Utils.LoadModel: line 3145, column 1 Class.skuid.ModelComponent.generate: line 49, column 1 Class.skuid.SkuidPage.processModelsNode: line 95, column 1 Class.skuid.SkuidPage.generate: line 654, column 1 Class.skuid.Ui.run: line 728, column 1 Class.skuid.Ui.initIfNecessary: line 119, column 1 Class.skuid.Ui.getPageType: line 150, column 1

Nothing has changed with regard to the Skuid page or the VF page, but we did update to Spring '17 the weekend this started happening.
 
Photo of Jack Sanford

Jack Sanford, Champion

  • 8,322 Points 5k badge 2x thumb
Did anyone figure out a fix for this? Getting this all of a sudden in one sandbox on Winter '19 and not in another on Winter '19. Both have skuid version 11.2.10 installed. In both situations the skuid page comes on a VF page, but the page is broken (with no details) when previewing, then when trying to load on the VF page I get the details below: 

SQLException in Class.skuid.Utils.LoadModelUnserialized: line 3683, column 1 Class.skuid.Utils.LoadModelUnserialized: line 3257, column 1 Class.skuid.Utils.LoadModel: line 3251, column 1 Class.skuid.ModelComponent.generate: line 54, column 1 Class.skuid.SkuidPage.processModelsNode: line 195, column 1 Class.skuid.SkuidPage.generate: line 630, column 1 Class.skuid.Ui.run: line 642, column 1 Class.skuid.Ui.initIfNecessary: line 117, column 1 Class.skuid.Ui.getPageType: line 148, column 1 


The page was working fine, and then it just wasn't. I was editing the page, but restoring to previous versions of the page doesn't work. Also, it's only this page, not any others. 

Photo of Jack Sanford

Jack Sanford, Champion

  • 8,322 Points 5k badge 2x thumb
Also, I had this error in 11.2.9 then upgrade to 11.2.10 to see if it helped, but same error. 
Photo of Jack Sanford

Jack Sanford, Champion

  • 8,322 Points 5k badge 2x thumb
A little more info - I had one model I unchecked load on page load, then added an action on a tab to load it - and when it tries to load, I get this error: 
Photo of Jack Sanford

Jack Sanford, Champion

  • 8,322 Points 5k badge 2x thumb
OKAY - figured it out - I had changed a date formula so that it pulled in a value from an encrypted field on a parent object. I guess when the value comes in from the encrypted field it turns it into text instead of a date. When I unencrypted that field things worked out. 
Photo of Mark DeSimone

Mark DeSimone, Official Rep

  • 11,040 Points 10k badge 2x thumb
Thanks for updating again. I've just found this known issue that seems to overlap a lot with what you're reporting:
https://success.salesforce.com/issues_view?id=a1p3A0000018Bf8QAE
It sounds like un-encrypting the field is the workaround, assuming it's a reasonable option for your use-case. 
Does this all sound right?
Photo of Jack Sanford

Jack Sanford, Champion

  • 8,322 Points 5k badge 2x thumb
yeah we have a workaround for now. thanks