In consistency check table is Object column and you should be able to see which column is corrupted. Then I would compare merged rpd with the modified to see the difference in the object before merge and after.

I will answer to myself :-) The key is this sentence. The Oracle BI Server truncates the timestamps to the number of digits that are defined by FRACTIONAL_SECOND_PRECISION. So in RPD in physical layer for DB set fractional second precision to value as timestamp so 6 and all works as a charm.

Question is how. I would use the alter session command linked to a variable but I'm not sure how to fill the variable with value of current locale... Is it LOCALE? But what init block to use?

Ok I was able to force NLS change via connection pool by alter session command. But there has to me some other way how to make it dynamic based on user profile settings. Can anybody point me to what config needs to be met?

Thanks Christian, let me check. It looks like the NLS is not dynamicly treated based on user profile settings. I will investigate.

something strange is happening now... It looks my account is now able to run the commands :-S I need to investigate further and once I have the correct answer I will mark it. Thanks all for now.

thanks Elb, these things I know and I have to admit the propagation time is awfull when you are testing something. But still it is not working even the users are part of "BIAdministrator" or "BIServiceAdministrator". Me is a good example. I'm the administrator and neither me can use the commands. So I'm forced to use…

Yes none of those can. Yes weblogic has DefaultAuthenticator as provider so is embedded. I'm not able somehow duplicate weblogic account...

Hm it looks it still doesn't work. I created those two new users and fullWLSadmin I added to the group Administrators in console. Second one justEMadmin I added only in EM to BIAdminstrators. None of those can run the command above. The error message changed (Connection failed: 401: Unauthorized) but I think the reason is…

I created a specific system of MUD. Where I created scripts to downlad rpd, do some work (offline), create patch, patch rpd and upload online to dev and test environment. It works perfect for almost two months now but the scripts are using weblogic account. This scares me a bit. So I would like to change this to download…

Tricky question Christian :-) I think I'm sure, but OBI still ensures me I can't be ever sure :-) So my contra question would be how or where to check it? Something says me that to be a part of BI administrator role (where weblogic is) is not enough is it?

thanks all for reacting. I'm running for example this command: datamodel.cmd downloadrpd -O {path} -SI ssi -U {user} -P {User pass} -W {rpd pass} -S {server} -N 9502 If I run it under weblogic it is wroking. Running under my account is failing to Connection failed, the server processes may be down, the host name, port…

Thanks Christian for useful info. As always :-) Specially the blog link looks helpful in compare to oracles ones... Once we do implement that I will try to share details.

Same browser. I did what you asked for Christian but no success. If I paste it to notepad it looks same as the source. I also crested analysis without any special charactet but the result is still the same. So in 12 version I see &quot instead of " and saving is not accepting the code with &quot... Petr

Ok in terms of english alphabet, yes I do :-) Ok I will check to have some analysis excluding any special characters and let's see. Nevertheless this was not a problem in 11.9g :-(

Hi Joel, thanks for replying to my issue. Actually I don't have any special characters in column name. The names are in standard way like "Table"."Column" but in SQL code it is visible as "Table"."column". I'm not using this New Analysis but the client does and is asking for fixing this. I adviced them to use other…

So after 2 moths communication and proving the issue to Oracle support the problem has been found. The problem is czech type of sorting. If you use czech NLS you have to set up. 1) In the NQSConfig.INI. set the following: LOCALE = "Czech"; SORT_ORDER_LOCALE = "Czech"; SORT_TYPE = "default"; 2) In the rpd, a) set the…

I understand you point and I did it already. Thing is we recently upgraded from 11 to 12 and even the architecture is the same and also all queries are the same in 11 and 12 version. During my investigation I came across the fact when I'm sorting the columns the sum of the rows is changing. Also I if a have two table in…

It looks like this is not a problem of IFNULL... This most likely happens when BI has to build the result from more then one query to db...

Thanks Christian, everything is the same in 11 and 12 version. And unfortunately I'm not familiar with log level 7 (how to read). Only I can say that SQL statements are the same. One report I was able to fix the problem by excluding the month detail which is not used in output so decreased the dataset 12times. But I´m not…