Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reporting & Analytics 9.x

Status
Not open for further replies.
9Coder

9Coder

IS-IT--Management
Apr 16, 2019
53
0
0
ID
Hi, anyone has installed/test install the reporting & analytics 9.x yet?
 
Sort by date Sort by votes
Lots of people have it running. Its been released over 3 years ago.



Specialist in creating custom applications for the Micros POS range: 3700, 9700, Simphony FE, Simphony. SIM Scripts, Data Exports, Simphony extension applications, API Creation and integration. If you need anything please contact me via my website
 
Upvote 0 Downvote
really, well I've already tried to install it - so far the installation went very smooth. But when I looked up simphony reports on the R&A such as (Employee Closed Check, Void Reason, etc) it throws me an error that said "Database Query Error" and in R&A 9.x we can't see the details of the errors just like in 8.5.x version. But on the other hand, the default R&A reports such as Daily Ops or Today ops or even Transaction summary (the drill-down reports) are working just fine. It's only the AdHoc Simphony Report on R&A just didn't work. Any idea, what steps did I missed?
 
Upvote 0 Downvote
try reinstall the R&A if it does not work , try change the report template you are trying to read
 
Upvote 0 Downvote
@cherifbj have you install R&A 9.x? can you open all the simphony reports such as Employee Closed Check report or another adhoc simphony reports on R&A? Since I've tried to reinstall & switch the report templates, still doesn't work.
 
Upvote 0 Downvote
Log in M organization. Go to your Organization from Admin -> Portal. Edit and at the end of the screen, enter Simphony DB login details. Save and restart the server. It should solve the issue.
 
Upvote 0 Downvote
@Dananjaya I didn't found any simphonydb credential field. I only found the opera fields below. Would you mind giving me a screenshot? I already did log in as sysadmin to M organization but haven't found any simphonydb field as you said

Capture_o3hnbw.png
 
Upvote 0 Downvote
@portalriki,

Could you please check the version of the R&A. Bcoz, 8.xx versions does not have this param.
R_AVersion_ir1a0s.jpg
 
Upvote 0 Downvote
@Dananjaya I'm using R&A 9.1.29 without OBIEE, the version you've attached was R&A 9.1.30 w/ OBIEE
 
Upvote 0 Downvote
@portalriki, I don't have access to the site as of now. But this is how I resolved the exact issue. Try with Super Admin which is CORE_USER ID is ZERO.
 
Upvote 0 Downvote
@Dananjaya I found it, last question (i hope) just to reconfirm do you fill the below-highlighted field "DB Suffix"? What exactly did you put in there?

Capture_i1ygbg.png
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

9Coder
  • Locked
  • Question
reset sys admin, reporting & analytics
Replies
4
Views
42
9Coder
9Coder
DatFatMan
  • Locked
  • Question
Running Micros 3700 EM - Want to update EM & stores
Replies
6
Views
101
myu0516
myu0516
King00788
  • Locked
  • Question
Simphony CAPS Not Posting Sales to R&A
Replies
10
Views
141
Niko S
Niko S
HDK
  • Locked
  • Question
RES 5.x install on new computer
Replies
4
Views
85
POSINSAM
POSINSAM
mvelazquez
  • Locked
  • Question
Code 9 - Failed to export report - Micros Res 3700
Replies
2
Views
78
anajmi
anajmi

Part and Inventory Search

Sponsor

Back
Top