You are not logged in.

Save Data Windows 7

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

  • 1
  • 2

Pommie

Sage

  • "Pommie" is male
  • "Pommie" started this thread

Posts: 412

Date of registration: Feb 21st 2007

Location: Lytham UK

Occupation: OLAP consultant specialising in retail

  • Send private message

1

Friday, May 7th 2010, 12:51pm

Save Data Windows 7

In XP I used to be able to start and stop the service and save data using the Palo Server Manager on the task bar

In Windows 7 with it's "you can't do it" approach to security it seems that clicking on these options does nothing. (Presumably because the save /stop / start commands are not "run as administrator")

Is there a way to make these work, or another way to force a save of the cube data without exiting Excel?
Best wishes

John Hobson
The Planning Factory, Lytham, UK
www.planfact.co.uk

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

2

Friday, May 7th 2010, 3:46pm

RE: Save Data Windows 7

you could try the admin interface in your web browser (edit the palo.ini to enable this)

jgibbs

Sage

  • "jgibbs" is male

Posts: 154

Date of registration: Dec 5th 2006

Location: Toronto

Occupation: Accountant

  • Send private message

3

Monday, May 10th 2010, 4:47pm

RE: Save Data Windows 7

Does Win7 have a services manager like XP? (Control Panel-> Administrative Tools-> Services)

Services displays all jobs running. You can start and stop the PSM there.

Pommie

Sage

  • "Pommie" is male
  • "Pommie" started this thread

Posts: 412

Date of registration: Feb 21st 2007

Location: Lytham UK

Occupation: OLAP consultant specialising in retail

  • Send private message

4

Monday, May 10th 2010, 5:37pm

@Axi - I haven't had time to check out the admmin interface but that's probably an answer.

@jgibbs - How do I add PSM to the list of services - it's not there at the moment?
Best wishes

John Hobson
The Planning Factory, Lytham, UK
www.planfact.co.uk

jgibbs

Sage

  • "jgibbs" is male

Posts: 154

Date of registration: Dec 5th 2006

Location: Toronto

Occupation: Accountant

  • Send private message

5

Tuesday, May 11th 2010, 8:14pm

Hi Pommie,

If you're able to launch the "services" program I'm surprised it wouldn't be there. I know you're pretty handy with cubes and windows so I apologize for saying things that might be obvious (but here goes :) ). I don't have win7 so I'm just guessing.

You're working on the host machine right? Maybe it's a rights issue but then I wonder why would win7 let you see any services that are running?

The list is alphabetical so (obviously) look under P.

Can you access the data in Excel? And you have the Palo icon in the systray?

That's all I have. Sorry.

Pommie

Sage

  • "Pommie" is male
  • "Pommie" started this thread

Posts: 412

Date of registration: Feb 21st 2007

Location: Lytham UK

Occupation: OLAP consultant specialising in retail

  • Send private message

6

Tuesday, May 11th 2010, 10:17pm

Ah - you are not talking about Palo MOLAP Server Service are you?

That doesn't have any save data option (apart from shut down which presumably saves data)

I was guessing that there was some sort of Palo Server Manager service you were referring to.....
Best wishes

John Hobson
The Planning Factory, Lytham, UK
www.planfact.co.uk

jgibbs

Sage

  • "jgibbs" is male

Posts: 154

Date of registration: Dec 5th 2006

Location: Toronto

Occupation: Accountant

  • Send private message

7

Wednesday, May 12th 2010, 3:40pm

Err, no. :rolleyes:

I need to be more technical. You are correct. However, even in our Windows environment, with the "Palo Server Manager" running in the system tray, I've never noticed that the "Save Database" button does anything. I've always just clicked "stop" and "start" to force a save.

Of course, I don't even do that now thanks to the help I got setting up a script to do a back up overnight.

Sorry for the confusion!

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

8

Wednesday, May 12th 2010, 4:20pm

http://localhost:7777/api/server/save

7777 is the port your palo server listens to

this link is not the solution ;-)
but gives you an idea where the lever is

This post has been edited 1 times, last edit by "axi" (May 12th 2010, 4:21pm)

Pommie

Sage

  • "Pommie" is male
  • "Pommie" started this thread

Posts: 412

Date of registration: Feb 21st 2007

Location: Lytham UK

Occupation: OLAP consultant specialising in retail

  • Send private message

9

Thursday, May 20th 2010, 2:31pm

Thanks AXI

I have worked out how to save a datbase but it's not pretty is it. :D

Does anyone have any idea why the old way (clicking on the button in the task bar) no longer works?
Best wishes

John Hobson
The Planning Factory, Lytham, UK
www.planfact.co.uk

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

10

Friday, May 21st 2010, 11:43am

user right management in Windows 7 - you are not admin but an ordinary user

one could check (programming task for the app developer!) wether the tray app is running under Windows 7 and if ask the user if he wants to perform this function

analogue to installing new software under Windows 7

under Linux I also have to change my hat from user to paloadmin to do these tasks - Windows 7 comes along ;-)

Pommie

Sage

  • "Pommie" is male
  • "Pommie" started this thread

Posts: 412

Date of registration: Feb 21st 2007

Location: Lytham UK

Occupation: OLAP consultant specialising in retail

  • Send private message

11

Friday, May 21st 2010, 12:14pm

Thanks - I have to admit tha I get terribly confused as to why Microsoft seem to distinguish between me having an account (the only one on the laptop) described as being an "admistrator" and the way they then treat the account as a non-admin account for anything that actually matters X(
Best wishes

John Hobson
The Planning Factory, Lytham, UK
www.planfact.co.uk

tgkk

Intermediate

Posts: 5

Date of registration: Jan 24th 2010

  • Send private message

12

Sunday, October 10th 2010, 12:05pm

Hi,

when is it necessary to force saving data?

So far I have done quite a bit of work with PALO - with XP up to now.

I hardly ever saved data manually - and I did not notice that I lost any data - nor any structural changes.

Is Palo not reliably auto-saving all information?

TG

tish1

Sage

Posts: 777

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

13

Tuesday, October 12th 2010, 11:36pm

Hi,

data is written to RAM and log files upon insertion in the cube. When you save your server (manually or during shutdown), the log files are merged into the csv files. If you kill your task, the log files will be merged into the csv files during the next startup.
Automatic saving can be set in the palo.ini, but it looks like there are problems with this function. You can find more infos on this in the Palo manual.

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

Cuitlahua

Professional

  • "Cuitlahua" is male

Posts: 32

Date of registration: Feb 27th 2009

Location: Hungary

  • Send private message

14

Wednesday, October 13th 2010, 1:20pm

Hi Tish!

What problems have you experienced with the automatic saving?

C.

Xpresson

Sage

Posts: 122

Date of registration: Aug 1st 2007

  • Send private message

15

Wednesday, October 13th 2010, 2:58pm

Can you guys please explain this manual save in "dummy's" english

I have tried to access the

http://127.0.0.1:7777/browser

I get this message
ACCESS DENIED
Please use the administration interface to access the server browser

1. Does this mean that I have to login as "administrator" for this to work?

2. By Stopping a Service and Restarting, am I effectively forcing a save on the database?
I can live with that if it is the easiest solution possible as I will just do a restart overnight.

Thanks heaps,

Xpresson

realquo

Sage

  • "realquo" is male

Posts: 257

Date of registration: Mar 11th 2009

Location: Italy

Occupation: BI Consultant

  • Send private message

16

Wednesday, October 13th 2010, 3:08pm

Yes Xpression,
forcing a restart will perform an actual save,

regards,
RQ

johntacon

Intermediate

  • "johntacon" is male

Posts: 13

Date of registration: May 29th 2007

Location: Freetown

Occupation: Freelance Consultant

  • Send private message

17

Saturday, January 29th 2011, 3:18pm

stop, start, save in win 7

Hi John,

Did you discover why the Stop, Start and Save functions in Palo Server Manager no longer work in Win 7. I am logged in to Win 7 as Administrator.

John

dominik_l

Jedox Team

  • "dominik_l" is male

Posts: 348

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

18

Monday, February 21st 2011, 5:26pm

We have fixed a problem with the Server Manager on Win7 in the meantime, please try this again with the enxt version (will be available soon).

tish1

Sage

Posts: 777

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

19

Monday, February 21st 2011, 9:00pm

Hi,

to open the admin interface via web, you have to put something like this in your palo.ini

Source code

 
1

admin "127.0.0.1" 7778


Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

johntacon

Intermediate

  • "johntacon" is male

Posts: 13

Date of registration: May 29th 2007

Location: Freetown

Occupation: Freelance Consultant

  • Send private message

20

Thursday, May 12th 2011, 7:27pm

Hi Dominik

In latest 3.1, I'm still not able to stop and save via service manager, in Win 7 (64-bit). I now also find i cannot clear a cube of obselete data. Both fucntions worked fine in XP, as you know.

Is there any 'fix' we can make to Win 7 ... or an update for 3.1 due to address the problems?
  • 1
  • 2
Rate this thread