81
Views
3
Comments
Solved
Query input parameter does not update when publish

I'm having an internal error due to Error executing query, but I found out that the query does not update after I publish it.


Query inside my studio platform:


[1] Error executing query.
   at ssBCP_Modules.Flows.FlowHotListReport.WBlkHotlistReportWB.FuncssPreparation.QueryGetHotlistReport(HeContext heContext, Int32 maxRecords, IterationMultiplicity multiplicity, Int64& outParamCount, DateTime qpdaGenerationDate, String qpstOrderBy, String qpstRoleParam, String qpstClusterParam, String qpstIndustryParam, String qpstAgencyParam, String qpstAnalystParam, String qpstCompanyParam, String qpstDispositionIdOtherReason, String qpstIsConsolidated)


I already deleted this input parameters but does not reflect after I publish it.


Looking for an advice, thank you very much.


2020-02-28 09-46-54
Eduardo Jauch
Solution

Hello Gerrick,

It seems to me that you have your SQL in one module and is using the Action/Screen Action where the SQL is located from a consumer module.

If so, you need to refresh dependences on the Consumer Module and publish the consumer module in order to it to use the newer version of the producer module.

Cheers.

2020-08-26 14-54-58
Raghuram kamath

Maybe you can write a new query and use that  and delete this query. 


Sometimes I find this sync issues too(Maybe due to Network issues or server not responding at that time). I wait for few hours reconnect and it starts to work.


2020-02-28 09-46-54
Eduardo Jauch
Solution

Hello Gerrick,

It seems to me that you have your SQL in one module and is using the Action/Screen Action where the SQL is located from a consumer module.

If so, you need to refresh dependences on the Consumer Module and publish the consumer module in order to it to use the newer version of the producer module.

Cheers.

2024-08-01 04-11-43
Maki Gurapo

Hi Eduardo,

Thank you very much! It works now perfectly!

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.