CslaGen exception at connecting to database

14 views
Skip to first unread message

Marcos Vinícius

unread,
Nov 24, 2009, 12:33:46 PM11/24/09
to CslaGenerator
Hi all,

This is the first time I'm trying to use the Gen, so excuse me for my
possible lack of ability to speak about it.

However, I noticed that when trying to connect to a specific database
on my local computer I get the error listed at the end of this post.
Just to make things clear: the connectiong succeeds when connecting to
other databases, except for this one (CoopsSql2005). The database is
generated automatically from a VSTS2005 database project in Visual
Studio 2008 and the general message is that I have an "Invalid column
name 'ROUTINE_Name'." I looked up for the column name but can't find
it.

Any ideas?


Consulte o final desta mensagem para obter detalhes sobre como chamar
a
depuração just-in-time (JIT) em vez desta caixa de diálogo.

************** Texto de Exceção **************
System.Data.SqlClient.SqlException: Invalid column name
'ROUTINE_Name'.
em CslaGenerator.GeneratorController.BuildSchemaTree(String
connectionString)
em CslaGenerator.GeneratorController.Connect()
em CslaGenerator.CSLAgen.Connect()
em CslaGenerator.CSLAgen.toolStripButton7_Click(Object sender,
EventArgs e)
em System.Windows.Forms.ToolStripItem.RaiseEvent(Object key,
EventArgs e)
em System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
em System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
em System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs
e)
em System.Windows.Forms.ToolStripItem.FireEventInteractive
(EventArgs e, ToolStripItemEventType met)
em System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e,
ToolStripItemEventType met)
em System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
em System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
button, Int32 clicks)
em System.Windows.Forms.Control.WndProc(Message& m)
em System.Windows.Forms.ScrollableControl.WndProc(Message& m)
em System.Windows.Forms.ToolStrip.WndProc(Message& m)
em System.Windows.Forms.Control.ControlNativeWindow.OnMessage
(Message& m)
em System.Windows.Forms.Control.ControlNativeWindow.WndProc
(Message& m)
em System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32
msg, IntPtr wparam, IntPtr lparam)


************** Conjuntos de Módulos (Assemblies) Carregados
**************
mscorlib
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3603 (GDR.050727-3600)
Base de Código: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
CslaGenerator
Versão do Conjunto de Módulos (Assembly): 1.0.2731.4564
Versão do Win32: 1.0.2731.4564
Base de Código: file:///D:/CslaGenerator/CslaGenerator.exe
----------------------------------------
System.Windows.Forms
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código:
file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código:
file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3082 (QFE.050727-3000)
Base de Código: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
mscorlib.resources
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3603 (GDR.050727-3600)
Base de Código: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
WeifenLuo.WinFormsUI.Docking
Versão do Conjunto de Módulos (Assembly): 1.0.0.0
Versão do Win32: 1.0.0.0
Base de Código: file:///D:/CslaGenerator/WeifenLuo.WinFormsUI.Docking.DLL
----------------------------------------
System.Windows.Forms.resources
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código:
file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_pt-BR_b77a5c561934e089/System.Windows.Forms.resources.dll
----------------------------------------
System.Data
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Design
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
DBSchemaInfo
Versão do Conjunto de Módulos (Assembly): 1.0.0.0
Versão do Win32: 1.0.0.0
Base de Código: file:///D:/CslaGenerator/DBSchemaInfo.DLL
----------------------------------------
System.XML.resources
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código:
file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml.resources/2.0.0.0_pt-BR_b77a5c561934e089/System.Xml.resources.dll
----------------------------------------
1t372svh
Versão do Conjunto de Módulos (Assembly): 1.0.2731.4564
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Accessibility
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Data.resources
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código:
file:///C:/WINDOWS/assembly/GAC_MSIL/System.Data.resources/2.0.0.0_pt-BR_b77a5c561934e089/System.Data.resources.dll
----------------------------------------
Microsoft.mshtml
Versão do Conjunto de Módulos (Assembly): 7.0.3300.0
Versão do Win32: 7.0.3300.0
Base de Código: file:///C:/WINDOWS/assembly/GAC/Microsoft.mshtml/7.0.3300.0__b03f5f7f11d50a3a/Microsoft.mshtml.dll
----------------------------------------
System.Transactions
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código:
file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código:
file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
SchemaExplorer
Versão do Conjunto de Módulos (Assembly): 2.6.0.117
Versão do Win32: 2.6.0.117
Base de Código: file:///D:/CslaGenerator/SchemaExplorer.DLL
----------------------------------------
System.resources
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código:
file:///C:/WINDOWS/assembly/GAC_MSIL/System.resources/2.0.0.0_pt-BR_b77a5c561934e089/System.resources.dll
----------------------------------------
System.Design.resources
Versão do Conjunto de Módulos (Assembly): 2.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código:
file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design.resources/2.0.0.0_pt-BR_b03f5f7f11d50a3a/System.Design.resources.dll
----------------------------------------
CodeSmith.Engine
Versão do Conjunto de Módulos (Assembly): 2.6.0.117
Versão do Win32: 2.6.0.117
Base de Código: file:///D:/CslaGenerator/CodeSmith.Engine.DLL
----------------------------------------
Microsoft.VisualBasic
Versão do Conjunto de Módulos (Assembly): 8.0.0.0
Versão do Win32: 8.0.50727.3053 (netfxsp.050727-3000)
Base de Código:
file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
Microsoft.JScript
Versão do Conjunto de Módulos (Assembly): 8.0.0.0
Versão do Win32: 8.0.50727.3053
Base de Código: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.JScript/8.0.0.0__b03f5f7f11d50a3a/Microsoft.JScript.dll
----------------------------------------
fslgvlno
Versão do Conjunto de Módulos (Assembly): 0.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
okddbprg
Versão do Conjunto de Módulos (Assembly): 0.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
44pv07ys
Versão do Conjunto de Módulos (Assembly): 0.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
y5-x4vyd
Versão do Conjunto de Módulos (Assembly): 0.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
qs1x5yo5
Versão do Conjunto de Módulos (Assembly): 0.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
ppwfz00h
Versão do Conjunto de Módulos (Assembly): 0.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
wolawjie
Versão do Conjunto de Módulos (Assembly): 0.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
tzu-2qld
Versão do Conjunto de Módulos (Assembly): 0.0.0.0
Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
Base de Código: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------

************** Depuração JIT **************
Para habilitar a depuração just-in-time (JIT), o arquivo .config deste
aplicativo ou computador (machine.config) deve ter o valor
jitDebugging definido na seção system.windows.forms.
O aplicativo também deve ser compilado com a depuração
habilitada.

Por exemplo:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

Quando a depuração JIT está habilitada, qualquer exceção não tratada
será enviada ao depurador JIT registrado no computador,
em vez de ser tratada nesta caixa de diálogo.

pandelis

unread,
Nov 25, 2009, 1:23:00 AM11/25/09
to CslaGenerator
Try accessing the xml file produced by cslagenerator. It should have
the name of your project. Inside u will find this node that will look
like sth like that

<ConnectionString>data source=SERVER2\SQLEXPRESS;initial
catalog=ERP_LOGISTIRIO;integrated security=SSPI;</ConnectionString>

Try putting your connection string inside

Marcos Vinícius

unread,
Nov 25, 2009, 6:13:12 AM11/25/09
to CslaGenerator
Ok...

First of all I was using the CslaGen version from 2007.

After downloading the new version from 2009, I thought the error would
go away BUT it didn't. So I used the database publishing wizard,
republished my database schema and created a new database exactly like
the other one.

And then, by miracle, the error was gone.

I figure out this must have something to do with some nasty piece of
code the T4 Toolbox is inserting and it is conflicting with the
CslaGen. Who knows...

Thanks guys,

Andrés Villanueva

unread,
Nov 25, 2009, 7:37:25 AM11/25/09
to cslage...@googlegroups.com
Hi Marcos,

My bet is that something went really wrong when the db was created. The column it reports as missing (ROUTINE_Name) is a column in one of the information_shcema views.
You can run this to check:
select * from information_schema.routines

2009/11/25 Marcos Vinícius <marcos...@gmail.com>



--
Andrés
Reply all
Reply to author
Forward
0 new messages