Cleaning up SQL buffer in Workbench

[Former Member]

Hi folks

How do I clean SQL buffer while working on BLS? Workbenc somehow keep some parameter in buffer and although I change it, and when I execute the transaction, the old parameter's value keep getting in the transaction

I know there is a possibility to clean JCO with this url http://<SERVER>:<PORT>/XMII/JCOProxy?Mode=Reset

but how about for SQL?

[Former Member]

Hi,

When you say buffer are you referring to the SQL "Query Caching" property?

If that is the case then take a look at http://help.sap.com/saphelp_mii121/helpdata/en/43/e80b59ad40719ae10000000a1553f6/frameset.htm and see if there is anything you are doing incorrectly.

Hope this helps.

Thanks

Udayan

[Former Member]

Hi Udayan

Unterfortunalely this is not what I want. The MII cache the development data somehow and there should be a service to clean this data.

sengkiang

[Former Member]

Hi,

I am not sure I understand, I'll try - what you are saying is that even though you do not use the Query Caching for your SQL query template , when this query is called from a transaction , it somehow gets cached? Is this correct?

Additionally, what MII version are you on?

Thanks

Udayan

[Former Member]

Let me try to explain

in my BLS i have an SQL, the input to this SQL action block is Param.1 . And for this Param.1 I fill in Date usinng Expression of Link editor (eg. formatdatenow("dd-MMM-yyyy hh:mm:ss"). And run the transaction.

When I change the Expression to other Date, and run the transaction MII keeps having the above Date and its format. I could see that with a tracer. And I think about 10-20 minutes later and rerun the transaction, the new Date is inserted. This means somehow MII cached somewhere the old value.

Version SAP MII 12.1

[Former Member]

Seng,

I am on MII 12.1.8 build 20 and I don't see this behavior in the WB. I have a query that fetches data from a MSSQL 2005 server.Every time I change Param.1 I get a different data set , no caching. Even if I try Query Caching explicitly , every time I change the Param.1 value I get a new data set.

Let me ask you this , are you experiencing this with only datetime data type or that doesn't matter?

Thanks

Udayan

[Former Member]

That doesnt matter

I experienced in once a while also in String. My co-workers also experience behaviors like that. We know that this problem will be solved by it self on the next day. But it is just anoying.

[jcgood25]

Transaction persistence or caching perhaps: http://help.sap.com/saphelp_mii122/helpdata/en/45/59840fe39065d1e10000000a1553f6/frameset.htm

Does the annoying time delay match up with the relevant settings?

[Former Member]

Nope, the only thing that matches the annoying experience is the ExpressionCacheDuration's setting. The value is 2 hours. But as mentioned we experience 20-30 minutes.

[Former Member]

Try:

If the issue is with transaction caching then use the service http://localhost:50000/XMII/Illuminator?Service=BLSManager&Mode=ClearCache

If the issue is with Query Caching then use : http://localhost:50000/XMII/Illuminator?Service=QueryCaching&Mode=ClearCache