[Help Thread] Please post your questions here.

[karmasa2012]

Hello there
I get the following error might help my sever Have

2016-02-12 17:41:55 Total: dbo.smp_read_max_awaken_option_sid Count: 1 PendingAVG: 0.000132(s) WorkingAVG: 0.062064(s)
2016-02-12 17:41:55 LongestPending: dbo.smp_read_max_awaken_option_sid Time: 0.000132(s) (at that time, ExecQuery: 1, RemainQuery: 1, PCCount: 0)
2016-02-12 17:41:55 LongestWorking: dbo.smp_read_max_awaken_option_sid Time: 0.062064(s) (at that time, ExecQuery: 1, RemainQuery: 1, PCCount: 0)
2016-02-12 17:42:30 Start DB Trace Dump count: 1
2016-02-12 17:42:30 Total: dbo.smp_read_max_awaken_option_sid Count: 1 PendingAVG: 0.000132(s) WorkingAVG: 0.062064(s)
2016-02-12 17:42:30 LongestPending: dbo.smp_read_max_awaken_option_sid Time: 0.000132(s) (at that time, ExecQuery: 1, RemainQuery: 1, PCCount: 0)
2016-02-12 17:42:30 LongestWorking: dbo.smp_read_max_awaken_option_sid Time: 0.062064(s) (at that time, ExecQuery: 1, RemainQuery: 1, PCCount: 0)
2016-02-12 17:42:30 Max Concurrent Query Count 1
2016-02-12 17:42:30 End DB Trace Dump

[ThunderNikk]

Have you taken a look at that SMP yet?

[Sherock]

can anyone convert this to SQL ?

[syglerice]

I have a little question about the database.
I used the files of epic 7.4 and 9.1 for info.

The question is : Where are the data about awakenoption of gear in 9.1 database ? Normally when i awake a gear, the awakenoption of the gear appear on dbo.Awakenoption on telecaster (on 7.4) and i see the dbo was here on the 9.1 database but when i awake gear, i have no data on the dbo.Awakenoption but they appear on the gear.

If anyone know, it will be very helpfull thanks

[ThunderNikk]

Have you checked to see if they are in dbo.RandomOption

[syglerice]

Originally Posted by thndr

Have you checked to see if they are in dbo.RandomOption

Yes i have look and nothing, i have restore the 2 database and do a reset of server and they have finally appear after on randomOption.
Thanks for ur help

[karmasa2012]

2016/02/15 15:49:20 DB COM ERROR(Thread:0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_OnStartUp(dbo.smp_read_max_awaken_option_sid) : Could not find stored procedure 'dbo.smp_read_max_awaken_option_sid'.
2016/02/15 17:32:05 DB COM ERROR(Thread:0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_OnStartUp(dbo.smp_read_max_awaken_option_sid) : Could not find stored procedure 'dbo.smp_read_max_awaken_option_sid'.
2016/02/15 17:33:06 DB COM ERROR(Thread:0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_OnStartUp(dbo.smp_read_max_awaken_option_sid) : Could not find stored procedure 'dbo.smp_read_max_awaken_option_sid'.

[ThunderNikk]

You need to explain what you are trying to do...

I dont have an smp for read_max_awaken_option_sid either

I do have read_max_random_option

If you read some of the posts around you it looks like they made some changes from epic 8 to epic 9 with awaken option and random option.

If you are trying to hybrid some multi epics together then it would be nice to know exactly what you are trying to do in order to maybe assist you better if anyone can assist at all.

[karmasa2012]

I am trying to migrate my database to new version 9. I copied arcadia and telecaster files. When I run CaptainHerlockServer.exe, I am getting following error:

"DB COM ERROR(Thread:0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_OnStartUp(dbo.smp_read_max_awaken_option_sid) : Could not find stored procedure 'dbo.smp_read_max_awaken_option_sid'."

What is smp stands for? Where can find data folder of it?

[SilentWisdom]

It seems you're using an inappropriate telecaster if you have such missing SMP

[karmasa2012]

I downloaded and altered stored procedures. now, there is no error but CaptainHerlockServer.exe not working. I looked into logs it stops after this log:
2016-02-16 17:01:12 Total 7722 Monster info loaded...

[ThunderNikk]

Ok I think what you are trying to do is keep your 8.1 telecaster data but run 9.1

In order to do that you will need to migrate your 8.1 telecaster data into the 9.1 telecaster.

You need to use the 9.1 arcadia and 9.1 telecaster and import your telecaster data.

There are some things that have changed so you may be able to write a proper SQL query to make it happen, or you may not be able to get it to work at all.

The one thing we miss from retail servers is the scripts that are written by the developers to make all of the changes to the databases to update from 8.4 to 9.1 the ratail servers just run a script. They don't change server database back up images.

[karmasa2012]

Where can I find empty 9.1 arcadia and telecaster databases? Can you post it?

Do you know if in 9.1 gameserver.opt and authserver.opt files are updated or changed? Should I find and change them too?

[ThunderNikk]

Telecaster will have to be emptied unless you use ismokedrows from the guide and SQL server 2014.

As for your second question you can follow the guide. They are pretty close to the same but that depends on whether or not you were using the auth emulator or the original retail auth.

[karmasa2012]

launher.bat is I get the error executing.