Hi ACL Support,

thanks for the attachments, although unfortunately for us all the Null Pointer Exception that you correctly identified as the cause of problem does not have a stack trace, this means we can't identify which line of code the NPE is coming from:
[code]
YF:2014-07-25 16:12:27: INFO (MIAdminAction:execute) - MIAdminAction entered
YF:2014-07-25 16:12:27: INFO (MIAdminAction:execute) - MIAdminAction exiting with action: newUser
YF:2014-07-25 16:12:27: INFO (MIPreUsersAction:execute) - MIPreUsersAction entered
YF:2014-07-25 16:12:27:ERROR (MIAdminProcess:loadRoles) - Error: java.lang.NullPointerException
YF:2014-07-25 16:12:31: INFO (MIEntryAction:execute) - MIEntryAction entered (/MIReEntry)
[/code]
and the localhost log file doesn't have the error at all.

We are wondering whether you are using Web Services, and whether you are using an incorrect role? Could you please send us the data from the tables:

OrgRole
StaffMemberHierarchy
AccessClassList

Also, if you run AXDB as a windows service could you please send us the stdout and stderr files in the hope of the full stack trace being in those logs.

regards,
Dave

Find attached the logs and the table contents.

Thanks,
ACL support

Hi,

Could you please provide any update on this issue?
I have attached the logs and table contents.

Let me know if you need more information.

Regards,
ACL support

Hi ACL Support,

thanks for the logs and tables, sorry but we need 2 more pieces of info, we are wondering whether your client is using Web Services?

Also, could you please tell us what build of Yellowfin you are using? (You can get this information from Administration->System Information):






regards,
Dave

Hi Dave,


Please find below the answers provided by user:

[Q:] Are you using Web services?
[Ans:] What do you mean web services?, we have installed with tomcat, and the unique user is admin@acl.com. In this server has not installed the IIS.

[Q:] Screenshot of the product build version.

[Ans:]
Find attached the screenshot
Application Version 6.3
Build : 20130725
Java Version: 1.7.0_21
OS: Win Server 2008 R2 6.1(x86)

[Q:] Contents of OrgRole table
[Ans:] Find attached

regards,
ACL support

Hi Dave,

Any updated about this?
let me know if you need more information from the user.

Regards,
Sainyam

Hi Sainyam,

Sorry for the delays.
We operate out of Melbourne, so we received these responses on our weekend when the office is closed.

Web services is a way to use YF functionality through your own code via integration.

I guess you're not using them, otherwise you would know ;).

We think we know where the problem lies then, and it's related to some bad data in your DB.

Can you please send across the results from the following 2 tables ;
-OrgReferenceCode
-OrgReferenceCodeDesc

Thanks,
David

Apologies for the delay.

User has sent the dump of Dashboard database.
Find attached.

Regards,
Sainyam

Hi Sainyam,

sorry but there isn't any attachment, could you please try again to attach it, or if you are having trouble attaching it then just email it to us, be sure to quote this forum post subject so that there is no mix-up.

regards,
Dave

Find attached again.

I am unable to attach the file. Please provide your email address.

Hi Sainyam,

You can just send it through to support@yellowfin.bi and reference this post.

Thanks,
David

Thanks David.

I have sent an email referencing this forum post in the email.

Regards,
Sainyam

Hi David,

The characterset is:
NLS_CHARACTERSET = WE8ISO8859P15

Could you please test this? The customer needs a response asap.

Thanks,
Sainyam

Hi Sainyam,

just letting you know that I've restored the AXDASHBOARD database and connected my instance of YF to it, but the strange thing is that I was able to create a new user successfully in it!

So there must be some other factor about your setup that we need over here to successfully reproduce the issue. I'm wondering whether it's a locale issue, so please tell us what locale Windows has been set to.

regards,
Dave

Windows locale is English

Hi David,

This issue is getting urgent now.

There is now another customer who is experiencing the same issue. I have asked for the same information so that its easier to narrow down the issue.

Thanks,
Sainyam

Hi Sainyam,

I finally was able to reproduce the issue. The key to reproducing the issue was to have the language set to Spanish. The YF database dump you sent us didn't have the language set to Spanish, that's why I wasn't able to reproduce the error at first. However, when I looked carefully through your DEBUG logs I saw the following line:

[code]
YF:2014-07-29 10:32:20:DEBUG (ReferenceCodeManager:selectReferenceCodeDescs) - ReferenceCodeDesc SELECT SQL:
SELECT RefTypeCode, RefVersion, LanguageCode, RefCode,
ShortDescription, LongDescription, ScreenSortOrder
FROM ReferenceCodeDesc
WHERE RefTypeCode = 'SECFN'
AND LanguageCode = 'ES'
[/code]

so when I set the language to ES in our restored instance of your YF database then I was able to reproduce the issue. A produce defect has been raised 172831 and has been marked as HIGH priority so that it will be fixed soon. In the meantime, if you change your language setting to english then you will be able to create a new user

regards,
Dave

Hi David,

Just a quick update for me. Will there be any fix for this defect anytime soon?

The browser settings by default are Spanish for the customers as its a organization based in LAC region.

Regards,
Sainyam

Hi Sainyam,

I'm sorry but it's too late in the month for a fix to make it into the build at the end of the month (Fri 26th), i.e. we are in the code-freeze phase of the month now, but it will definitely be fixed first thing after the patch.

Are you aware that you can change the Yellowfin language setting from within the application (in other words, the user doesn't have to change the browser settings):







this makes the workaround of changing the language to english momentarily to create the user and then back to spanish after the user has been created a quick and easy step.

regards,

Dave

Hi Sainyam,

good news, one of the developers has found that the issue doesn't need a code-fix to resolve it, it can be resolved by running the following SQL:

[code]DELETE FROM ReferenceCodeDesc WHERE SHORTDESCRIPTION is null[/code]

So please run that against your Yellowfin database and let us know how it goes.

Please don't forget to backup the database first!

regards,
Dave