Forum Discussion
Appling connection rights Error as Invalid column name 'scheduleid'.
Hello,
I copy my power bi database to new server. I installed a new version of power bi server and selected 'Choose an existing database' option.
In the last step 'Appling connection rights' I got an error with following description. I don't have an idea where is the problem.
Could you please help me? Thanks,
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'scheduleid'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(SqlConnection conn, String script, ICommandWrapperFactory commandWrapper)
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
ClientConnectionId:6863a17b-95ef-4cab-90cb-74201085f7b9
Error Number:207,State:1,Class:16
ozandikerler wrote:
I copy my power bi database to new server. I installed a new version of power bi server and selected 'Choose an existing database' option.
Is this database from the same version as the instance you just installed? If the database is from an older release I'd suggest you install the old release first, connect to the database, then upgrade the instance to the latest release. The reason for this is that I believe the installer will make schema changes to the database when it does an upgrade install. It sounds like you have attempted to connect a new release to an old database schema.
3 Replies
- d_gosbell
Super User
ozandikerler wrote:
I copy my power bi database to new server. I installed a new version of power bi server and selected 'Choose an existing database' option.
Is this database from the same version as the instance you just installed? If the database is from an older release I'd suggest you install the old release first, connect to the database, then upgrade the instance to the latest release. The reason for this is that I believe the installer will make schema changes to the database when it does an upgrade install. It sounds like you have attempted to connect a new release to an old database schema.
Thank you. I couldn't find any 'update power bi ' section or button in the RS settings. Should I download and install new power bi report server over the older one? If I do this, do I have any problem with old reports?
- d_gosbell
ozandikerler wrote:
Should I download and install new power bi report server over the older one? If I do this, do I have any problem with old reports?
Yes, we do this every 4 months when a new update is released and have not seen any issues. Of course it's always a good idea to make sure you have a recent back up before doing any upgrade just in case.
