[Dev] Server 4.2 Release support

I'm stuck on pet procedures.

Quote:

---

Originally Posted by WarriorSW

I fixed preety all just one what i have to do its complete CrystalSystem tables and it will be like original DB (NGC Infl War working corectly, pet socket, level, name working, arena maps ragnarok armagedon working, InfinityField 1,2,3 working) , About crystals i just started to work with them but i have a quite problem with sequencenumbers ( if its not a random when beat one crystal then rest of them dissapear but its under construction now), ahh i almost forget, all bins cleaned and deleted that shitty welcome message

about procedure/table:

Proc:

Code:

---

USE [atum2_db_1]
GO
/****** Object:  StoredProcedure [dbo].[atum_load_ti_itemmixingelement]    Script Date: 2014-04-03 14:51:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[atum_load_ti_itemmixingelement]
AS
        SELECT UniqueID,ItemNum,Count FROM atum2_db_account.dbo.ti_itemmixingelement WITH (NOLOCK);

---

Table (Copied from table design):

Code:

---

UniqueID        int        Checked
ItemNum        int        Checked
Count        int        Checked
                Unchecked

---

Youre welcome

---

Yeah I tried that first before I wrote the other and I see what I did wrong. Note to self - try not to code at 4 am when your brain is dead. I forgot to add any data to the table.

Edit: Ok still not working, :/ well the procedure is but not sure why its not accepting the data I put into the table.

Any idea with this:

Code:

---

4-04 00:58:40|[Notify] ItemEvent reloaded !!, ItemEvent Count(112)
04-04 00:58:42|ERROR: CAtumDBHelper::LoadItemMixingInfo() Failed!!!
04-04 00:58:42|[Error] FieldServer IOCPInit Error
04-04 00:58:48|  [Notify] CFieldGlobal::EndServerSocket#
04-04 00:58:48|CGlobalGameServer::EndServerSocket_1

---

It's the procedure incorrect I assume.

Procedure and table incorrect. In ti_mixinginfo should be products only and in mixinginfoelements ingreediens. server match them by col uniquenumber

USE [atum2_db_1]
GO

/****** Object: StoredProcedure [dbo].[atum_import_ti_itemmixingelement] Script Date: 04-Apr-14 9:13:47 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


--------------------------------------------------------------
-- ti_ItemMixingElement µ¥ÀÌÅÍ »ý¼º °ü·Ã
--------------------------------------------------------------
-- !!!!
-- Name:
-- Desc: // 2009-07-09 by jwlee, °ÔÀÓ Á¤º¸ Å×ÀÌºí µ¥ÀÌÅÍ DB¿¡ ¹Ð¾î³Ö±â Åø ±¸Çö -
-- // 2012-02-20 by hskim, DB Á¤±ÔÈ­ - ItemMixingInfo
-- ====
CREATE PROCEDURE [dbo].[atum_import_ti_itemmixingelement]
@uniqueid INT,
@sourceItemNum INT,
@sourceItemCount INT
-- // 2009-02-17 by cmkwon, MARK for Yedang -- // 2008-09-04 by cmkwon, ¿¹´ç º¸¾È°ü·Ã ¼û±ä °èÁ¤ Àû¿ë Çϱâ(SQL Server 2005ÀÌ»ó¸¸ Áö¿øÇÏ´Â ±â´É) -
AS
INSERT INTO atum2_db_account.dbo.ti_ItemMixingElement(UniqueID, SourceItemNum, SourceItemCount)
VALUES @uniqueid, @sourceItemNum, @sourceItemCount)

GO

I have a problem with DBLoadInitializedGuild, I made the procedures InitializedGuild but when I start field server, Profiler stops in atum_LeaderCandidate.

I was seeing if there are something need to change but there are no diferences between leadercandidate ep3.5 and ep4.3.

I added values but nothing.

I dont know how but now, it stopped in Delete_InitializedGuildList, my procedures are based in thread [REQUEST]procedure 4.2 by WarriorSW

check load Pet and PetLevel procedures

Gabe I was talking about procedure of Load_ti_ItemMixingInfo. That procedure is for import.

Quote:

---

Originally Posted by WarriorSW

check load Pet and PetLevel procedures

---

I checked it but the same error:
My Delete_InitializedGuildList

Quote:

---

USE [atum2_db_1]
GO
/****** Object: StoredProcedure [dbo].[atum_Delete_InitializedGuildList] Script Date: 04/04/2014 18:21:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[atum_Delete_InitializedGuildList]
AS


RETURN

---

My PetLevel Procedure:

Quote:

---

ALTER PROC [dbo].[atum_Load_ti_petLevel]
--@i_PetIndex INT
AS

BEGIN
SELECT PetIndex, PetLevel, NeedExp, UseWeaponIndex, SlotCountSkill, SlotCountSocket, KitLevelHP, KitLevelShield, KitLevelSP FROM atum2_db_1.dbo.ti_PetLevel --WHERE PetIndex = @i_PetIndex;
END

---

Profiler stops in Delete_InitializedGuildList

yea i know but i se here that procedure is from ep 3.5 my procedure is difrent is from ep 4>>> what u know i have the complete DB for ep 4 and and al file server waiting to my frend to ghive this day the complete surce> but that pocedure is difrend and is the saime table

Quote:

---

dbo_ty_itemmixinginfo

---

and that is the last procedure i share

Any ideas about this?

Code:

---

04-05 02:55:00|        szSqlState    = 42000
04-05 02:55:00|        pfNativeError = 8144
04-05 02:55:00|        szErrorMsg    = [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function atum_log_insert_total_user has too many arguments specified.
04-05 02:55:00|        pcbErrorMsg  = 129

04-05 02:55:00|        ODBCRowNumber = 1
04-05 02:55:00|        SSrvrLine    = 1
04-05 02:55:00|        SSrvrMsgState = 2
04-05 02:55:00|        SSrvrSeverity = 16
04-05 02:55:00|        SSrvrProcname = atum_log_insert_total_user
04-05 02:55:00|        SSrvrSrvname  = MIHAI-52E9F83AC

04-05 02:55:00|[DB Error] DBWorkerThreadID( 6060) hstmt(0xAA3618): [COLOR="#FF0000" @Atum_log_insert_total_user Failed![/COLOR]

04-05 02:55:00|        szSqlState    = 42000
04-05 02:55:00|        pfNativeError = 8144
04-05 02:55:00|        szErrorMsg    = [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function atum_log_insert_total_user has too many arguments specified.
04-05 02:55:00|        pcbErrorMsg  = 129

04-05 02:55:00|        ODBCRowNumber = 1
04-05 02:55:00|        SSrvrLine    = 1
04-05 02:55:00|        SSrvrMsgState = 2
04-05 02:55:00|        SSrvrSeverity = 16
04-05 02:55:00|        SSrvrProcname = atum_log_insert_total_user
04-05 02:55:00|        SSrvrSrvname  = MIHAI-52E9F83AC

04-05 02:55:14|[ERROR] CSPToMPWinSocket Timeout !!
04-05 03:00:00|[DB Error] DBWorkerThreadID( 5120) hstmt(0xAA7DF0): @Atum_log_insert_total_user Failed!

---

and here's the procedure:

Code:

---

USE [atum2_db_account]
GO
/****** Object:  StoredProcedure [dbo].[atum_PROCEDURE_080827_0087]    Script Date: 04/05/2014 02:55:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


--------------------------------------------------------------------------------
-- PROCEDURE NAME        : dbo.atum_PROCEDURE_080827_0087
-- DESC                                : -- // 2008-08-27 by cmkwon, ³¯Äõ¸®¸¦ Procedure·Î ¼öÁ¤ -
--------------------------------------------------------------------------------
ALTER PROCEDURE [dbo].[atum_PROCEDURE_080827_0087]
AS
        UPDATE dbo.td_account
        SET ConnectingServerGroupID = 0;

---

Too many arguments? I cannot see too many arguments...

It means that 1 or more arguments have been passed to the procedure and your procedure was not set up to handle it accordingly.
On a side note, the procedure you're showing here is not the one mentioned in your log files.

Code:

---

USE [atum2_db_account]
GO

/****** Object:  StoredProcedure [dbo].[atum_log_insert_total_user]    Script Date: 05.04.2014 7:38:57 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

    CREATE PROCEDURE [dbo].[atum_log_insert_total_user]
        @i_ServerGroupName            VARCHAR(20),   
        @i_MGameServerID            INT,
        @i_UserCount                INT,
        @i_nUserCountsOtherPublisherConncect                INT
    AS
        INSERT INTO atum_log_total_user
        VALUES (GetDate(), @i_ServerGroupName, @i_MGameServerID, @i_UserCount, @i_nUserCountsOtherPublisherConncect)

GO

---

Code:

---


USE [atum2_db_account]
GO

/****** Object:  Table [dbo].[atum_log_total_user]    Script Date: 05.04.2014 7:38:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[atum_log_total_user](
    [Time] [datetime] NULL,
    [ServerGroupName] [varchar](20) NULL,
    [MGameServerID] [int] NULL,
    [UserCount] [int] NULL,
    [UserCountsOtherPublisherConncect] [int] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

---

I realized that exist an error in PreServer logs as

Code:

---

04-05 10:33:36|[ERROR] CSPToMPWinSocket Timeout !!

---

Meanwhile, in FieldServer start to spam this:

Code:

---

04-05 10:33:58|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1508] PoolCnt[ 1002] CommitSize[ 1511424] vectorSize[3] Address Range(0x7EEA0000 ~ 0x7F011000)
04-05 10:33:58|  [Notify] LogError, Index(  2) CLogWinSocket(0x1337010) SendBufferSize( 501)
04-05 10:33:58|  [Notify] LogError, Index(  2) CLogWinSocket(0x1337010) SendBufferSize( 502)
04-05 10:33:58|  [Notify] LogError, Index(  2) CLogWinSocket(0x1337010) SendBufferSize( 503)

---

with different BufferSize()

Hi,

you have an idea or it may come:
http://image.noelshack.com/fichiers/...8797-error.png
http://image.noelshack.com/fichiers/...eserverlog.png

thanks in advance for your help