Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing
L2JForge.live Interlude Premium Emulator
  • 0

L2 Cached - Sql 42000 Error

GARAB

Asked by GARAB,

 Share

Question

GARAB Newbie

GARAB

Posted
Posted

Hi all!

 

 

Maybe I'm getting a little irritating wtih my questions, but I hope this will be one of the last ones.

So our CacheD server can't do it's job. It start and connects to log server, and the server itself can connect to it. The problem is that it can save the NPCbosses, or cant createlin attack time record.

 

Error sql: EXEC lin_DreateTimeAttackRecord 3, 2, 0, 0, 0, 0, 0, 0, N'', N'',0 ,0 (0)
Error 42000:[Microsoft][ODBC SQL Server Driver]
Could not find stored procedure 'lin_CreateTimeAttackRecord'.
 
and some korean stuff, with this:
[korean text][207] Cannot creat time attack info room_no[5], record_type=[2]
 
So, the ODBC is okay, it connects to the proper database, and the user has permissons in mssql, to execute, write, etc, etc, so full control and the stored procedures are there, so they exist.
 
Any ideas? Thanks!
 
08/10/2014 22:59:57.964, Error sql: UPDATE castle SET next_war_time = 1366552800 WHERE id = 7 (0)
08/10/2014 22:59:57.964, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:57.986, Error sql: EXEC lin_SaveCastleStatus 1, 3 (0)
08/10/2014 22:59:57.986, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:57.986, Error occurred in Saving Castle Status
08/10/2014 22:59:57.986, Error sql: UPDATE castle SET next_war_time = 1366552800 WHERE id = 3 (0)
08/10/2014 22:59:57.986, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:58.236, Error sql: DELETE FROM castle_war WHERE castle_id = 4 (0)
08/10/2014 22:59:58.236, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:58.242, Error sql: EXEC lin_SaveCastleStatus 0, 4 (0)
08/10/2014 22:59:58.242, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.242, Error occurred in Saving Castle Status
08/10/2014 22:59:58.243, Error sql: EXEC lin_LoadNpcBoss N'dr_chaos_gigantic_golem' (0)
08/10/2014 22:59:58.243, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_LoadNpcBoss'.
08/10/2014 22:59:58.243, [.\NpcDbSocket.cpp][1016] No record in table, npc dbname[dr_chaos_gigantic_golem]
08/10/2014 22:59:58.243, Error sql: EXEC lin_SaveNpcBoss N'dr_chaos_gigantic_golem',0,0,0,0,0,0,0,0 (0)
08/10/2014 22:59:58.243, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveNpcBoss'.
08/10/2014 22:59:58.243, [.\NpcDbSocket.cpp][1024] Save NpcBoss Failed! Npc DBName[dr_chaos_gigantic_golem]
08/10/2014 22:59:58.373, Error sql: DELETE FROM castle_war WHERE castle_id = 8 (0)
08/10/2014 22:59:58.373, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:58.381, Error sql: EXEC lin_SaveCastleStatus 0, 8 (0)
08/10/2014 22:59:58.381, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.381, Error occurred in Saving Castle Status
08/10/2014 22:59:58.425, Error sql: DELETE FROM castle_war WHERE castle_id = 9 (0)
08/10/2014 22:59:58.425, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:58.431, Error sql: EXEC lin_SaveCastleStatus 0, 9 (0)
08/10/2014 22:59:58.431, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.431, Error occurred in Saving Castle Status
08/10/2014 22:59:58.463, Error sql: DELETE FROM castle_war WHERE castle_id = 1 (0)
08/10/2014 22:59:58.463, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:58.474, Error sql: EXEC lin_SaveCastleStatus 0, 1 (0)
08/10/2014 22:59:58.474, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.474, Error occurred in Saving Castle Status
08/10/2014 22:59:58.621, Error sql: EXEC lin_LoadNpcBoss N'freya_royalguard' (0)
08/10/2014 22:59:58.621, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_LoadNpcBoss'.
08/10/2014 22:59:58.621, [.\NpcDbSocket.cpp][1016] No record in table, npc dbname[freya_royalguard]
08/10/2014 22:59:58.621, Error sql: EXEC lin_SaveNpcBoss N'freya_royalguard',0,0,0,0,0,0,0,0 (0)
08/10/2014 22:59:58.621, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveNpcBoss'.
08/10/2014 22:59:58.621, [.\NpcDbSocket.cpp][1024] Save NpcBoss Failed! Npc DBName[freya_royalguard]
08/10/2014 22:59:58.712, Error sql: DELETE FROM castle_war WHERE castle_id = 2 (0)
08/10/2014 22:59:58.713, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:58.722, Error sql: EXEC lin_SaveCastleStatus 0, 2 (0)
08/10/2014 22:59:58.722, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.722, Error occurred in Saving Castle Status
08/10/2014 22:59:58.809, Error sql: DELETE FROM castle_war WHERE castle_id = 6 (0)
08/10/2014 22:59:58.809, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:58.817, Error sql: EXEC lin_SaveCastleStatus 0, 6 (0)
08/10/2014 22:59:58.817, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.817, Error occurred in Saving Castle Status
08/10/2014 22:59:58.903, Error sql: DELETE FROM castle_war WHERE castle_id = 5 (0)
08/10/2014 22:59:58.903, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:58.913, Error sql: EXEC lin_SaveCastleStatus 0, 5 (0)
08/10/2014 22:59:58.913, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.913, Error occurred in Saving Castle Status
08/10/2014 22:59:58.973, Error sql: EXEC lin_SaveCastleStatus 2, 7 (0)
08/10/2014 22:59:58.973, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.973, Error occurred in Saving Castle Status
08/10/2014 22:59:58.978, Error sql: EXEC lin_SaveCastleStatus 2, 3 (0)
08/10/2014 22:59:58.978, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.978, Error occurred in Saving Castle Status
08/10/2014 22:59:59.231, Error sql: EXEC lin_SaveCastleStatus 1, 4 (0)
08/10/2014 22:59:59.231, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.231, Error occurred in Saving Castle Status
08/10/2014 22:59:59.241, Error sql: UPDATE castle SET next_war_time = 1367690400 WHERE id = 4 (0)
08/10/2014 22:59:59.241, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:59.370, Error sql: UPDATE castle SET next_war_time = 1367690400 WHERE id = 8 (0)
08/10/2014 22:59:59.370, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:59.371, Error sql: EXEC lin_SaveCastleStatus 1, 8 (0)
08/10/2014 22:59:59.371, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.371, Error occurred in Saving Castle Status
08/10/2014 22:59:59.427, Error sql: UPDATE castle SET next_war_time = 1367690400 WHERE id = 9 (0)
08/10/2014 22:59:59.427, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:59.427, Error sql: EXEC lin_SaveCastleStatus 1, 9 (0)
08/10/2014 22:59:59.427, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.427, Error occurred in Saving Castle Status
08/10/2014 22:59:59.462, Error sql: EXEC lin_SaveCastleStatus 1, 1 (0)
08/10/2014 22:59:59.462, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.462, Error occurred in Saving Castle Status
08/10/2014 22:59:59.463, Error sql: UPDATE castle SET next_war_time = 1367690400 WHERE id = 1 (0)
08/10/2014 22:59:59.463, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:59.711, Error sql: EXEC lin_SaveCastleStatus 1, 2 (0)
08/10/2014 22:59:59.711, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.711, Error occurred in Saving Castle Status
08/10/2014 22:59:59.721, Error sql: UPDATE castle SET next_war_time = 1367690400 WHERE id = 2 (0)
08/10/2014 22:59:59.721, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:59.744, Error sql: EXEC lin_LoadNpcBoss N'benom' (0)
08/10/2014 22:59:59.744, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_LoadNpcBoss'.
08/10/2014 22:59:59.744, [.\NpcDbSocket.cpp][1016] No record in table, npc dbname[benom]
08/10/2014 22:59:59.744, Error sql: EXEC lin_SaveNpcBoss N'benom',0,0,0,0,0,0,0,0 (0)
08/10/2014 22:59:59.744, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveNpcBoss'.
08/10/2014 22:59:59.745, [.\NpcDbSocket.cpp][1024] Save NpcBoss Failed! Npc DBName[benom]
08/10/2014 22:59:59.805, Error sql: EXEC lin_SaveCastleStatus 1, 6 (0)
08/10/2014 22:59:59.805, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.805, Error occurred in Saving Castle Status
08/10/2014 22:59:59.806, Error sql: UPDATE castle SET next_war_time = 1367762400 WHERE id = 6 (0)
08/10/2014 22:59:59.806, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:59.899, Error sql: EXEC lin_SaveCastleStatus 1, 5 (0)
08/10/2014 22:59:59.899, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.899, Error occurred in Saving Castle Status
08/10/2014 22:59:59.909, Error sql: UPDATE castle SET next_war_time = 1367762400 WHERE id = 5 (0)
08/10/2014 22:59:59.909, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:59.971, Error sql: DELETE FROM castle_war WHERE castle_id = 7 (0)
08/10/2014 22:59:59.971, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:59.971, Error sql: EXEC lin_SaveCastleStatus 0, 7 (0)
08/10/2014 22:59:59.971, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.971, Error occurred in Saving Castle Status
08/10/2014 22:59:59.986, Error sql: DELETE FROM castle_war WHERE castle_id = 3 (0)
08/10/2014 22:59:59.986, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:59.989, Error sql: EXEC lin_SaveCastleStatus 0, 3 (0)
08/10/2014 22:59:59.989, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.989, Error occurred in Saving Castle Status
 

 

6 answers to this question

Recommended Posts

  • 0
xeL Apprentice

xeL

Posted
Posted

I use the Vanganth 1.2.3.6 pack, that was among the shared files on the forum.

Is shared by me and has all needed sql. Should run ok. For sure you didn't installed something.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to question listing


  • Posts

    • Huggo
      L2JMobius ClassicLude P110 + Interface Source

      By Huggo · Posted

      In your place l will join to Mobius community to get something decent or just go to Lucera 2 ( ofc no source) if you want interlude on Classic client, coz Acis not have have it yet.
    • jethwebs
      L2JMobius ClassicLude P110 + Interface Source

      By jethwebs · Posted

      The client and the system aren't working very well; the screen is black, and some things aren't loading.  😞 
    • VPSLab
      — VPSLAB — Fast & Private RDP/VPS | 100% Instant Setup

      By VPSLab · Posted

      Active & Taking orders!
    • Sonic3
      [L2J] LINEAGE2.SK

      By Sonic3 · Posted

      LINEAGE2.SK Summer Season is Comming! GRAND OPENING - 14.08.2026 at 20:00 GMT+1  OBT - 07.08.2025 at 20:00 GMT+1   Website :https://lineage2.sk Discord : https://discord.gg/gj7AC5juGP       Server Features and Rates Xp – 20x Sp – 20x Adena – 10x Drop – 15x Spoil - 15x  Epic Raid Boss  - 1x Regular RB - 5x  Quest - 5x Fame - 2x Epaulette - 15x Manor - 15x     Special Features Somik Interface Limited AutoFarm Vote System Champions System Achievement System And more in information below     Enchant Settings  Safe Enchant: +3  Max Enchant: +16 Enchant Chance: 63%  Attribute Stone Chance: 50%  Attribute Crystal Chance: 30%     NPC Buffer all buffs, songs, dances including 3rd prof + resists Buff Slots: 24 (+4) / 12 Buff Duration: 2 Hours     Epic Bosses & Respawns Queen Ant: 24 hours +/-8h Core: 3 days +/-8h Orfen: 2 days +/-8h Baium: 5 days +/-8h Beleth: 7 days +/-8h Antharas: 7 days +/-8h Valakas: 7 days +/-8h     Instances Zones Zaken: 6 players Normal Freya: 6 players Hard Freya: 12 Players Frintezza: 6 Players Tiat: 6 Players Beleth: 12 Players     GM Shop weapon/armor/jwl (max S grade) shots/spiritshots (max S grade) mana potions (1000 MP, 10s)      Global Gatekeeper all towns including cata/necro ToI Gracia Hellbound ...     Olympiad period 7 days (Monday) no class participants min 6 base class participants min 6 max enchant +6 Start points 20     Class Transfer for Adena     Subclass Quest Not required Max Subclass 3 Subclass Max LvL 85     Events Team vs Team Capture the Flag Death Match Last Hero Korean Style Treasure Hunt      Clans All new clans start with Clan LvL 5! Clan Skills/LvL for Clan Coins     Others  max 3 windows per HWID  BoM/MoM spawned in towns Auto-learn skills Autoloot Retail LvL of Epic Bosses Cancellation return buff system (30sec) Cancellation return buff -  not effect olympiad
    • Sonic3
      [L2J] LINEAGE2.SK

      By Sonic3 · Posted

      LINEAGE2.SK Summer Season is Comming! GRAND OPENING - 14.08.2026 at 20:00 GMT+1  OBT - 07.08.2025 at 20:00 GMT+1   Website :https://lineage2.sk Discord : https://discord.gg/gj7AC5juGP       Server Features and Rates Xp – 20x Sp – 20x Adena – 10x Drop – 15x Spoil - 15x  Epic Raid Boss  - 1x Regular RB - 5x  Quest - 5x Fame - 2x Epaulette - 15x Manor - 15x     Special Features Somik Interface Limited AutoFarm Vote System Champions System Achievement System And more in information below     Enchant Settings  Safe Enchant: +3  Max Enchant: +16 Enchant Chance: 63%  Attribute Stone Chance: 50%  Attribute Crystal Chance: 30%     NPC Buffer all buffs, songs, dances including 3rd prof + resists Buff Slots: 24 (+4) / 12 Buff Duration: 2 Hours     Epic Bosses & Respawns Queen Ant: 24 hours +/-8h Core: 3 days +/-8h Orfen: 2 days +/-8h Baium: 5 days +/-8h Beleth: 7 days +/-8h Antharas: 7 days +/-8h Valakas: 7 days +/-8h     Instances Zones Zaken: 6 players Normal Freya: 6 players Hard Freya: 12 Players Frintezza: 6 Players Tiat: 6 Players Beleth: 12 Players     GM Shop weapon/armor/jwl (max S grade) shots/spiritshots (max S grade) mana potions (1000 MP, 10s)      Global Gatekeeper all towns including cata/necro ToI Gracia Hellbound ...     Olympiad period 7 days (Monday) no class participants min 6 base class participants min 6 max enchant +6 Start points 20     Class Transfer for Adena     Subclass Quest Not required Max Subclass 3 Subclass Max LvL 85     Events Team vs Team Capture the Flag Death Match Last Hero Korean Style Treasure Hunt      Clans All new clans start with Clan LvL 5! Clan Skills/LvL for Clan Coins     Others  max 3 windows per HWID  BoM/MoM spawned in towns Auto-learn skills Autoloot Retail LvL of Epic Bosses Cancellation return buff system (30sec) Cancellation return buff -  not effect olympiad

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..