SQL Server 2012

nurikabe

• May 15, 2012 00:00

• Answered

Follow

Having trouble importing metadata for SQL Server 2012. I can pull up a list of tables, but then trying to browse a table returns "Invalid object" errors. JDBC compatibility problem perhaps?

Thanks

• 

  vacekm

  • May 16, 2012 14:37

  0

  Comment actions Permalink

  Hello,
  
  could you please provide us with the log file which is located in your project folder under .metadata/.log
  Clover officialy supports SQL server up to 2008. However the log might tell us more about why is this happening.
• 

  nurikabe

  • May 16, 2012 17:30

  0

  Comment actions Permalink

  It doesn't look like the error is being logged:
  
  

  
  !SESSION 2012-05-16 13:26:38.777 -----------------------------------------------
  eclipse.buildId=M20100909-0800
  java.version=1.6.0_29
  java.vendor=Sun Microsystems Inc.
  BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US
  Framework arguments:  -product com.cloveretl.gui.product.community.designer
  Command-line arguments:  -os win32 -ws win32 -arch x86_64 -product com.cloveretl.gui.product.community.designer
  
  !ENTRY org.eclipse.osgi 2 1 2012-05-16 13:26:47.987
  !MESSAGE NLS unused message: Columns_text in: org.eclipse.ui.internal.views.properties.messages
  
  !ENTRY org.eclipse.osgi 2 1 2012-05-16 13:26:47.988
  !MESSAGE NLS unused message: Columns_toolTip in: org.eclipse.ui.internal.views.properties.messages
  
  !ENTRY org.eclipse.osgi 2 1 2012-05-16 13:26:47.989
  !MESSAGE NLS unused message: Selection_description in: org.eclipse.ui.internal.views.properties.messages
  
  !ENTRY org.eclipse.osgi 2 1 2012-05-16 13:26:47.990
  !MESSAGE NLS unused message: Pin_text in: org.eclipse.ui.internal.views.properties.messages
  
  !ENTRY org.eclipse.osgi 2 1 2012-05-16 13:26:47.991
  !MESSAGE NLS unused message: Pin_toolTip in: org.eclipse.ui.internal.views.properties.messages
  

  
  
  But the attached is the error I am getting.

  • Invalid Object Error.png
• 

  vacekm

  • May 17, 2012 08:23

  0

  Comment actions Permalink

  Hello,
  
  is the SQL query any complicated? There's a known bug that for some cases of queries the extraction fails. The bug is reported here https://bug.javlin.eu/browse/CLD-3657
  If you simplify the query, does it still fail? The known problems causing this are:
  query has a semicolon ; at the end
  query contains nested query
  query has some functions in the view part
  
  This might be your case, maybe you could provide us with the SQL query and also try running the extraction with simplified query.
• 

  nurikabe

  • May 17, 2012 14:22

  0

  Comment actions Permalink

  No, no actual SQL yet. Just trying to browse the data via the tree.
• 

  vacekm

  • May 18, 2012 08:33

  0

  Comment actions Permalink

  Hello,
  
  we will check compatibility with SQL Server 2012 and let you know. I opened an issue CL-2301 in our tracking system for this.
• 

  vacekm

  • May 22, 2012 13:10

  0

  Comment actions Permalink

  We have investigated the compatibility with the SQL server 2012 and found out the message you're getting is probably caused when you're trying to browse a table that doesn't belong under default schema of your DB user. Currently you can't browse the list of tables that aren't in your default schema, but checking the option "Prefix table names with schema" before generating query allows you to extract metadata from a table that belongs under different schema (but only all the columns can be extracted).
• 

  nurikabe

  • May 29, 2012 20:49

  0

  Comment actions Permalink

  Same problem when checking that box. Problem is likely due to my lack of understanding of default schemas in MSSQL. Will investigate.

Please sign in to leave a comment.