Install hangs when populating ReportFieldTemplate
15 December, 2009
Yellowfin Data Import Utility
=======================================
Reading properties file
Initialising db connection
Loading Infrastructure Code
log4j:WARN No appenders could be found for logger (com.hof.util.DBConnect).
log4j:WARN Please initialize the log4j system properly.
Performing JDBC connections... OK
172 [main] INFO util.PropertyMessageResources - Initializing, config='org.apache.struts.util.LocalStrings', returnNull=
true
172 [main] INFO util.PropertyMessageResources - Initializing, config='com.hof.ApplicationResources', returnNull=true
Reading data file
Importing data
541984 [main] WARN util.DBAction - Error occured closing result set: TDS Protocol error: Invalid packet type 0xb6
541984 [main] ERROR util.DBAction - Error occured creating DB statement: java.sql.SQLException: Invalid state, the Conn
ection object is closed.
541984 [main] ERROR util.DBAction - Error occured doing insert: java.lang.Exception: DBAction.creatStmt() exception
541984 [main] ERROR manager.ReportFieldTemplateManager - Errors occured inserting into ReportFieldTemplate: Invalid sta
te, the Connection object is closed.
541984 [main] ERROR manager.ReportFieldTemplateManager - SQL Stmt:
INSERT INTO ReportFieldTemplate ( ColumnName, GroupCode, ShortDescription, LongDescription,
SortOrder, FieldTypeCode, DataTypeCode, RefTypeCode, RefRltshpTypeCode,
FormatCode, ValidationFunctionName, ViewId, ReportSymbol, SQLClause,
HierarchyLevel, ChildColumnName, AssociatedReportId, StatusCode,
AccessFilterCode, DecimalCount, DisplayPermitted, CalculationPermitted,
GroupingPermitted, SortPermitted, AccessCode, DefaultGroupFunctionCode,
SubViewId, ModifiedDate, CustomDataType, TrendCode) VALUES (
N'Medium',N'WORKINGSETSNAPSHOTDETAILS',N'Medium',N'Medium',0,N'MEASURE',N'INTEGER',null,null,N'INTEGER',null,20703,null,
null,0,null,0,N'OPEN',null,0,1,1,1,1,N'GLOBAL',null,0,0,null,null)
541984 [main] ERROR process.MIReportExportImportProcess - Error: java.sql.SQLException: Invalid state, the Connection o
bject is closed.
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1713)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.getAutoCommit(ConnectionJDBC2.java:2134)
at com.hof.util.i4Connection.getAutoCommit(Unknown Source)
at com.hof.util.DBAction.rollback(Unknown Source)
at com.hof.util.DBAction.doInsert(Unknown Source)
at com.hof.mi.manager.ReportFieldTemplateManager.insertReportFieldTemplate(Unknown Source)
at com.hof.mi.process.MIReportExportImportProcess.importReportView(Unknown Source)
at com.hof.mi.process.MIReportExportImportProcess.importAdminItems(Unknown Source)
at com.hof.standalone.ImportData.main(Unknown Source)
541984 [main] ERROR util.DBAction - Error occured when disconnecting from the database:
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1713)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.getAutoCommit(ConnectionJDBC2.java:2134)
at com.hof.util.i4Connection.getAutoCommit(Unknown Source)
at com.hof.util.DBAction.rollback(Unknown Source)
at com.hof.util.DBAction.disconnect(Unknown Source)
at com.hof.mi.process.MIReportExportImportProcess.importReportView(Unknown Source)
at com.hof.mi.process.MIReportExportImportProcess.importAdminItems(Unknown Source)
at com.hof.standalone.ImportData.main(Unknown Source)
541984 [main] ERROR util.DBAction - Error occured when disconnecting from the database:
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1713)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.getAutoCommit(ConnectionJDBC2.java:2134)
at com.hof.util.i4Connection.getAutoCommit(Unknown Source)
at com.hof.util.DBAction.rollback(Unknown Source)
at com.hof.util.DBAction.disconnect(Unknown Source)
at com.hof.mi.process.MIReportExportImportProcess.importAdminItems(Unknown Source)
at com.hof.standalone.ImportData.main(Unknown Source)
An error occured loading your details from the database.
Please try again later.
D:AlterpointAnalyticsyellowfinimportExecutables>echo setting alterpoint configuration
setting alterpoint configuration
D:AlterpointAnalyticsyellowfinimportExecutables>java com.alterpoint.portal.init.SetUpAlterpointConfig d:Alterpoint
Analyticsyellowfin
Setting Alterpoint Values in the Configuration table...
Deleting yellowfin content OOTB...
Remove DOC export permission and PageFormat permission...
Removing ability to create and/or remove datasources...
Insterting tab categories...
Updating to new ORP groups and roles...
=======================================
Reading properties file
Initialising db connection
Loading Infrastructure Code
log4j:WARN No appenders could be found for logger (com.hof.util.DBConnect).
log4j:WARN Please initialize the log4j system properly.
Performing JDBC connections... OK
172 [main] INFO util.PropertyMessageResources - Initializing, config='org.apache.struts.util.LocalStrings', returnNull=
true
172 [main] INFO util.PropertyMessageResources - Initializing, config='com.hof.ApplicationResources', returnNull=true
Reading data file
Importing data
541984 [main] WARN util.DBAction - Error occured closing result set: TDS Protocol error: Invalid packet type 0xb6
541984 [main] ERROR util.DBAction - Error occured creating DB statement: java.sql.SQLException: Invalid state, the Conn
ection object is closed.
541984 [main] ERROR util.DBAction - Error occured doing insert: java.lang.Exception: DBAction.creatStmt() exception
541984 [main] ERROR manager.ReportFieldTemplateManager - Errors occured inserting into ReportFieldTemplate: Invalid sta
te, the Connection object is closed.
541984 [main] ERROR manager.ReportFieldTemplateManager - SQL Stmt:
INSERT INTO ReportFieldTemplate ( ColumnName, GroupCode, ShortDescription, LongDescription,
SortOrder, FieldTypeCode, DataTypeCode, RefTypeCode, RefRltshpTypeCode,
FormatCode, ValidationFunctionName, ViewId, ReportSymbol, SQLClause,
HierarchyLevel, ChildColumnName, AssociatedReportId, StatusCode,
AccessFilterCode, DecimalCount, DisplayPermitted, CalculationPermitted,
GroupingPermitted, SortPermitted, AccessCode, DefaultGroupFunctionCode,
SubViewId, ModifiedDate, CustomDataType, TrendCode) VALUES (
N'Medium',N'WORKINGSETSNAPSHOTDETAILS',N'Medium',N'Medium',0,N'MEASURE',N'INTEGER',null,null,N'INTEGER',null,20703,null,
null,0,null,0,N'OPEN',null,0,1,1,1,1,N'GLOBAL',null,0,0,null,null)
541984 [main] ERROR process.MIReportExportImportProcess - Error: java.sql.SQLException: Invalid state, the Connection o
bject is closed.
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1713)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.getAutoCommit(ConnectionJDBC2.java:2134)
at com.hof.util.i4Connection.getAutoCommit(Unknown Source)
at com.hof.util.DBAction.rollback(Unknown Source)
at com.hof.util.DBAction.doInsert(Unknown Source)
at com.hof.mi.manager.ReportFieldTemplateManager.insertReportFieldTemplate(Unknown Source)
at com.hof.mi.process.MIReportExportImportProcess.importReportView(Unknown Source)
at com.hof.mi.process.MIReportExportImportProcess.importAdminItems(Unknown Source)
at com.hof.standalone.ImportData.main(Unknown Source)
541984 [main] ERROR util.DBAction - Error occured when disconnecting from the database:
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1713)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.getAutoCommit(ConnectionJDBC2.java:2134)
at com.hof.util.i4Connection.getAutoCommit(Unknown Source)
at com.hof.util.DBAction.rollback(Unknown Source)
at com.hof.util.DBAction.disconnect(Unknown Source)
at com.hof.mi.process.MIReportExportImportProcess.importReportView(Unknown Source)
at com.hof.mi.process.MIReportExportImportProcess.importAdminItems(Unknown Source)
at com.hof.standalone.ImportData.main(Unknown Source)
541984 [main] ERROR util.DBAction - Error occured when disconnecting from the database:
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1713)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.getAutoCommit(ConnectionJDBC2.java:2134)
at com.hof.util.i4Connection.getAutoCommit(Unknown Source)
at com.hof.util.DBAction.rollback(Unknown Source)
at com.hof.util.DBAction.disconnect(Unknown Source)
at com.hof.mi.process.MIReportExportImportProcess.importAdminItems(Unknown Source)
at com.hof.standalone.ImportData.main(Unknown Source)
An error occured loading your details from the database.
Please try again later.
D:AlterpointAnalyticsyellowfinimportExecutables>echo setting alterpoint configuration
setting alterpoint configuration
D:AlterpointAnalyticsyellowfinimportExecutables>java com.alterpoint.portal.init.SetUpAlterpointConfig d:Alterpoint
Analyticsyellowfin
Setting Alterpoint Values in the Configuration table...
Deleting yellowfin content OOTB...
Remove DOC export permission and PageFormat permission...
Removing ability to create and/or remove datasources...
Insterting tab categories...
Updating to new ORP groups and roles...
Hello Support,
I had cut and paste fail. Here is some additional information.
We have a client on 64 window with MSSQL 2003. During yellowfins portion of the install the ReportFieldTemplate is populated and the following logs are produced.
I had cut and paste fail. Here is some additional information.
We have a client on 64 window with MSSQL 2003. During yellowfins portion of the install the ReportFieldTemplate is populated and the following logs are produced.
Hi,
This message:
[quote]Error occured closing result set: TDS Protocol error: Invalid packet type 0xb6[/quote]
Indicates a problem communicating with the Yellowfin database.
Does the import process run for a long time before this error occurs? If so it may be that the database server is closing the server after a timeout period is reached.
It could also indicate network connection problems between the server that runs Yellowfin and the database server (if these are on separate servers).
The import tool should create a log file called standaloneJDBC.log, which should have more information about the error. Could you post this file, or send it to support@yellowfin.com.au.
Thanks,
Steve
This message:
[quote]Error occured closing result set: TDS Protocol error: Invalid packet type 0xb6[/quote]
Indicates a problem communicating with the Yellowfin database.
Does the import process run for a long time before this error occurs? If so it may be that the database server is closing the server after a timeout period is reached.
It could also indicate network connection problems between the server that runs Yellowfin and the database server (if these are on separate servers).
The import tool should create a log file called standaloneJDBC.log, which should have more information about the error. Could you post this file, or send it to support@yellowfin.com.au.
Thanks,
Steve
Steve,
Here is the log file you requested.
James
Here is the log file you requested.
James