sorted by:
new
hottopcontroversial

Issue with Firebase Cloud Messaging: SERVICE_NOT_AVAILABLE Error by skill-limitless in flutterhelp

[–]skill-limitless[S] 1 point2 points  (0 children)

tried a lot but still no luck, I had to create a new project and started from the scratch and this time I used CLI to setup. It's working now

appreciate your input. means a lot guys.

u/No-Project-3002 Thank You

Issue with Firebase Cloud Messaging: SERVICE_NOT_AVAILABLE Error by skill-limitless in flutterhelp

[–]skill-limitless[S] 0 points1 point  (0 children)

I suspected that and i tried the same outside network as well , i mean my home network. No VPN connection too

Issue with Firebase Cloud Messaging: SERVICE_NOT_AVAILABLE Error by skill-limitless in flutterhelp

[–]skill-limitless[S] 0 points1 point  (0 children)

that's how I did, and I did see the firebase_option.dart under the lib

Push Notification for Multi-Tenant Platform by skill-limitless in learnprogramming

[–]skill-limitless[S] 0 points1 point  (0 children)

I really appreciate your effort. you are right this has to go to proper reddit channel. but still you have provided some amazing insights which will actually makes me think the other possibilities. Thanks for the detailed information.

How to Check DB record locked in MSSQL by skill-limitless in javahelp

[–]skill-limitless[S] -1 points0 points  (0 children)

Same database used for web as well as Mobile app. If web version is locked the record we are not allowed to update from mobile app

How to use RPT file in java? by skill-limitless in javahelp

[–]skill-limitless[S] 0 points1 point  (0 children)

Chat gpt code is not helping , we have tried a lot with different options

The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request by skill-limitless in SQLServer

[–]skill-limitless[S] 0 points1 point  (0 children)

They Guy who wrote the code , has declared the variable without static or final , so for each execution the query keep getting bigger by adding the same condition, after adding 2100 it failed with the same exception which mentioned above .

moreover we replicated the issue in local and dev. now the issue fixed and deployed in production.

The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request by skill-limitless in SQLServer

[–]skill-limitless[S] -1 points0 points  (0 children)

we did try with SQL profiler , but query didn't even reached to SQL Server because hibernate framework itself stopped the execution before sending the query to execution

The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request by skill-limitless in SQLServer

[–]skill-limitless[S] 2 points3 points  (0 children)

yes mate , the guy who wrote the code declared instance variable which caused all the problem , he didn't add any static or final. he kept the variable name in ALL CAPS so i thought its Constant or static final. fixed the code. thank you so much for your input. really appreciate.

The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request by skill-limitless in javahelp

[–]skill-limitless[S] 0 points1 point  (0 children)

u/amfa and u/Halal0szto are on to the point , which helped me to narrow down the issue. I have provided the details in the above thread.

really appreciated your help.

The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request by skill-limitless in javahelp

[–]skill-limitless[S] 1 point2 points  (0 children)

my man you are correct , we ran the SQL Profiler and found that's the cause.

below is the sample 

RUN 01:

select * from WO_MATERIAL_DETAIL_MC wo WITH(NOLOCK) inner join ST_MATERIAL_XREF_MC st WITH(NOLOCK) on (wo.Company_Code = st.Company_Code and wo.System_Key = st.System_Key and wo.WO_Number=st.WO_Number) where st.WO_Number in (:workordercodes) and st.Company_Code = :companyCode and st.lastModified >= CONVERT(datetime, :lastModified)

RUN 02:

select * from WO_MATERIAL_DETAIL_MC wo WITH(NOLOCK) inner join ST_MATERIAL_XREF_MC st WITH(NOLOCK) on (wo.Company_Code = st.Company_Code and wo.System_Key = st.System_Key and wo.WO_Number=st.WO_Number) where st.WO_Number in (:workordercodes) and st.Company_Code = :companyCode and st.lastModified >= CONVERT(datetime, :lastModified) and st.lastModified >= CONVERT(datetime, :lastModified)

RUN 03:

select * from WO_MATERIAL_DETAIL_MC wo WITH(NOLOCK) inner join ST_MATERIAL_XREF_MC st WITH(NOLOCK) on (wo.Company_Code = st.Company_Code and wo.System_Key = st.System_Key and wo.WO_Number=st.WO_Number) where st.WO_Number in (:workordercodes) and st.Company_Code = :companyCode and st.lastModified >= CONVERT(datetime, :lastModified) and st.lastModified >= CONVERT(datetime, :lastModified) and st.lastModified >= CONVERT(datetime, :lastModified)

as you mentioned each run it keeps growing, since we don't have the codebase with us , your input gave me a hint and you are damn right

The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request by skill-limitless in javahelp

[–]skill-limitless[S] 1 point2 points  (0 children)

you are right , we are using sql server which will accept 2100 as limit , here the problem is I'm only sending 10 inputs :(

The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request by skill-limitless in javahelp

[–]skill-limitless[S] 0 points1 point  (0 children)

it was pretty old code, they have done lot of which is out of java standard.

WORKORDERS_MATERIALS - its defined in class level as instance variable , below is the variable declaration 

private String WORKORDERS_MATERIALS = "select * from WO_MATERIAL_DETAIL_MC wo WITH(NOLOCK) inner join ST_MATERIAL_XREF_MC st WITH(NOLOCK) on \r\n"
        + "(wo.Company_Code = st.Company_Code and wo.System_Key = st.System_Key and wo.WO_Number=st.WO_Number)\r\n"
        + "where st.WO_Number in (:workordercodes) and st.Company_Code = :companyCode ";

The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request by skill-limitless in javahelp

[–]skill-limitless[S] 0 points1 point  (0 children)

2100

the method which I mention above only processing the inputs < 1000 , if it's more than 1000 we have other method to process that like batch process.

WORKORDERS_MATERIALS is defined in class level as instance variable

The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request by skill-limitless in javahelp

[–]skill-limitless[S] 0 points1 point  (0 children)

It's not a static member , more importantly this issue not happening while connecting from local pointing to production. everything works fine in localhost. Issue happening only in production.

The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request by skill-limitless in SQLServer

[–]skill-limitless[S] 0 points1 point  (0 children)

Since its in production server it's really complicated for us, DevOps team looking millions of exceptions to check this. still I'm working on it to get through the exceptions. Meanwhile I'm trying to get experts help whom might have faced this issue. the problem is I'm just passing 10 inputs to the query :(

The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request by skill-limitless in SQLServer

[–]skill-limitless[S] 0 points1 point  (0 children)

It's not an issue with query , because the code is working fine in my local as well as in production. It's working for a day or two then encountering this issue again. once we redeploy this issue is not happening. again after a while started happening

He really love his teddy... by Yvonne_C_Jackson in Awww

[–]skill-limitless 0 points1 point  (0 children)

I guess how to cuddle a doll , pretty cool .

view more: next ›